APPS.IGI_DUNN_POST_UPG_PKG dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 178: UPDATE hz_cust_prof_class_amts hcpca

174: AND NVL(idclsl.site_use_id,-99)= NVL(hcpa.site_use_id, -99));
175:
176: /*Added the below query to update schedule_id and interest_type in Customer Profile Class Amount*/
177:
178: UPDATE hz_cust_prof_class_amts hcpca
179: SET (interest_type, interest_schedule_id,
180: last_updated_by, last_update_date) =
181: (SELECT distinct DECODE(idls.charge_per_invoice_flag, 'Y', 'CHARGES_SCHEDULE', 'N', 'CHARGE_PER_TIER'),
182: l_schedule_id,