APPS.CS_CONTPNTS_AUDIT_UPD_CON_PRG dependencies on CS_HZ_SR_CONTACT_PNTS_AUDIT

Line 96: INSERT INTO cs_hz_sr_contact_pnts_audit

92: x_batch_size,
93: TRUE);
94:
95: WHILE (l_any_rows_to_process = TRUE) LOOP
96: INSERT INTO cs_hz_sr_contact_pnts_audit
97: (sr_contact_point_audit_id,
98: sr_contact_point_id,
99: incident_id,
100: party_id,

Line 158: FROM cs_hz_sr_contact_pnts_audit a

154: WHERE rowid BETWEEN l_start_rowid AND l_end_rowid
155: AND creation_date > l_cutoff_date -- <4507823/>
156: AND NOT EXISTS (
157: SELECT 'x'
158: FROM cs_hz_sr_contact_pnts_audit a
159: WHERE a.sr_contact_point_id = cp.sr_contact_point_id);
160:
161: l_rows_processed := SQL%ROWCOUNT;
162: