APPS.CSC_PARTY_MERGE_PKG dependencies on CSC_CUSTOMERS_AUDIT_HIST

Line 8: -- CSC_CUSTOMERS, CSC_CUSTOMERS_AUDIT_HIST,

4: -- Package name : CSC_PARTY_MERGE_PKG
5: -- Purpose : Merges duplicate parties in Customer Care tables. The
6: -- Customer Care table that need to be considered for
7: -- Party Merge are:
8: -- CSC_CUSTOMERS, CSC_CUSTOMERS_AUDIT_HIST,
9: -- CSC_CUSTOMIZED_PLANS, CSC_CUST_PLANS,
10: -- CSC_CUST_PLANS_AUDIT
11: --
12: -- History

Line 196: insert into csc_customers_audit_hist (

192: program_id = ARP_STANDARD.PROFILE.PROGRAM_ID,
193: program_update_date = trunc(SYSDATE)
194: where party_id = p_from_fk_id;
195:
196: insert into csc_customers_audit_hist (
197: cust_hist_id, party_id, last_update_date,
198: last_updated_by, last_update_login, creation_date,
199: created_by, changed_date, changed_by,
200: sys_det_critical_flag, override_flag, overridden_critical_flag,

Line 205: csc_customers_audit_hist_s.nextval, p_to_fk_id, sysdate,

201: override_reason_code, request_id,
202: program_application_id,
203: program_id, program_update_date)
204: values (
205: csc_customers_audit_hist_s.nextval, p_to_fk_id, sysdate,
206: g_user_id, g_login_id, sysdate,
207: g_user_id, sysdate, g_user_id,
208: 'N', l_from_override_flag, l_from_overridden_crit_flag,
209: l_from_override_reason_code , G_REQUEST_ID,