Update or insert record based on table column

Insert Into Next_Action_By_Days_Detail
			  (Job_ID_Key,
  			 Processing_timeStamp,
	  		 Organization_Number,
		  	 Lender_Number,
			   Days,
  			 Property_State_Abbreviation,
	  		 Loan_Number,
		  	 Payee_Code,
			   ZC_Jurisdiction_LDesc,
  			 Payee_Parcel_Number,
	  		 Next_Action_Date,
		  	 Next_Action_Type_MLDesc,
			   Contact_Notes)
  		Select
	  	    GenerateData.Job_ID_Key,
		  	  vCurrDate,
          GenerateData.Organization_Number,
			    l.Lender_Number,
  			  nvl(dp.Next_Action_Date, vCurrDate) - vCurrDate as Days,
	    		l.Property_State_Abbreviation,
          l.loan_number,
		    	lpp.Payee_Code,
  		  	j.ZC_Jurisdiction_LDesc,
	  		  dp.Payee_Parcel_Number,
  		  	dp.Next_Action_Date,
	  		  dp.Next_Action_Type_MLDesc,
  	  		dp.Notes
  	  From
		    	Loan l,
			    Delq_Parcel dp
			   Left Join Lender_Payee_Profile lpp on
			      lpp.Lender_Payee_Code = dp.Lender_Payee_Code
            and nvl(lpp.Inactive_ind,'NO') = 'NO'
  			  Left Join ZC_Jur_List j on
	  		    j.ZC_Jurisdiction_Code = Lpp.Payee_Code
            and nvl(j.Inactive_ind,'NO') = 'NO',
  		  Lender lr
  	  Where
          Dp.delq_loan_key=l.delq_loan_Key
		  and nvl(l.inactive_ind,'NO') = 'NO'
      and nvl(lr.inactive_ind,'NO') = 'NO'
	    And nvl(Dp.Next_Action_type_MLDesc,'@#$%^') <> '@#$%^'
		  And Upper(dp.Next_Action_Type_MLDesc)  not like
                         vTempDesc
  	  And lr.Organization_Number = GenerateData.Organization_Number
	  	And ((vLender_Number <=  0
			     And l.Lender_Number = lr.Lender_Number)
  		  Or (vLender_Number > 0
	  	     And l.Lender_Number = vLender_Number
           And lr.lender_number = l.Lender_Number))
		  And lpp.Lender_Number = l.Lender_Number;
 
      commit;
      
      Insert Into Next_Action_By_Days_Detail
			  (Job_ID_Key,
  			 Processing_timeStamp,
	  		 Organization_Number,
		  	 Lender_Number,
			   Days,
  			 Property_State_Abbreviation,
	  		 Loan_Number,
		  	 Payee_Code,
			   ZC_Jurisdiction_LDesc,
  			 Payee_Parcel_Number,
	  		 Next_Action_Date,
		  	 Next_Action_Type_MLDesc,
			   Contact_Notes)
  		Select
	  	    GenerateData.Job_ID_Key,
		  	  vCurrDate,
          GenerateData.Organization_Number,
			    l.Lender_Number,
  			  nvl(dp.Next_Action_Date, vCurrDate) - vCurrDate as Days,
	    		l.Property_State_Abbreviation,
          l.loan_number,
		    	lpp.Payee_Code,
  		  	j.ZC_Jurisdiction_LDesc,
	  		  dp.Payee_Parcel_Number,
  		  	dp.Next_Action_Date,
          dp.ccsd_status_desc,
  	  		dp.Notes
  	  From
		    	Loan l,
			    Delq_Parcel dp
			   Left Join Lender_Payee_Profile lpp on
			      lpp.Lender_Payee_Code = dp.Lender_Payee_Code
            and nvl(lpp.Inactive_ind,'NO') = 'NO'
  			  Left Join ZC_Jur_List j on
	  		    j.ZC_Jurisdiction_Code = Lpp.Payee_Code
            and nvl(j.Inactive_ind,'NO') = 'NO',
  		  Lender lr
  	  Where
          Dp.delq_loan_key=l.delq_loan_Key
		  and nvl(l.inactive_ind,'NO') = 'NO'
      and nvl(lr.inactive_ind,'NO') = 'NO'
	    And nvl(Dp.ccsd_status_desc,'@#$%^') <> '@#$%^'
		  And Upper(dp.ccsd_status_desc)  not like
                         vTempDesc
  	  And lr.Organization_Number = GenerateData.Organization_Number
	  	And ((vLender_Number <=  0
			     And l.Lender_Number = lr.Lender_Number)
  		  Or (vLender_Number > 0
	  	     And l.Lender_Number = vLender_Number
           And lr.lender_number = l.Lender_Number))
		  And lpp.Lender_Number = l.Lender_Number;
      
      commit;

                                  

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:
70:
71:
72:
73:
74:
75:
76:
77:
78:
79:
80:
81:
82:
83:
84:
85:
86:
87:
88:
89:
90:
91:
92:
93:
94:
95:
96:
97:
98:
99:
100:
101:
102:
103:
104:
105:
106:
107:
108:
109: