APPS.IGI_DUNN_POST_UPG_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 146: UPDATE hz_cust_profile_amts hcpa

142: END IF;
143: --dbms_output.put_line('Inserted Rows in ar_charge_schedules : '|| SQL%ROWCOUNT);
144:
145:
146: UPDATE hz_cust_profile_amts hcpa
147: SET (interest_type, /*interest_fixed_amount,*/ interest_schedule_id,
148: last_updated_by, last_update_date) =
149: (SELECT distinct DECODE(idls.charge_per_invoice_flag, 'Y', 'CHARGES_SCHEDULE', 'N', 'CHARGE_PER_TIER'),
150: /*interest_fixed_amount column is used if interest_type is 'FIXED_AMOUNT' - mbremkum*/

Line 200: --dbms_output.put_line('Updated Rows in hz_cust_profile_amts : '|| SQL%ROWCOUNT);

196: AND idclsl.customer_profile_class_id = hcpca.profile_class_id
197: AND idclsl.currency_code = hcpca.currency_code
198: AND hcpca.currency_code = r_aging_bkts.ccy_code);
199:
200: --dbms_output.put_line('Updated Rows in hz_cust_profile_amts : '|| SQL%ROWCOUNT);
201:
202: SELECT aging_bucket_id INTO l_aging_bucket_id
203: FROM ar_aging_buckets
204: WHERE description = r_aging_bkts.name;

Line 412: UPDATE hz_cust_profile_amts hcpa

408: Put_Debug_Msg(l_full_path, 'Customer Profile ID(Site Override): ' || r_aging_bkt_lines_site.customer_profile_id);
409: Put_Debug_Msg(l_full_path, 'Schedule ID(Site Override): ' || l_schedule_id);
410: END IF;
411:
412: UPDATE hz_cust_profile_amts hcpa
413: SET (interest_type, interest_schedule_id,
414: last_updated_by, last_update_date) =
415: (SELECT distinct DECODE(idls.charge_per_invoice_flag, 'Y', 'CHARGES_SCHEDULE', 'N', 'CHARGE_PER_TIER'),
416: l_schedule_id,-1, SYSDATE