DBA Data[Home] [Help]

APPS.CS_CONTPNTS_AUDIT_UPD_CON_PRG dependencies on CS_HZ_SR_CONTACT_POINTS

Line 44: l_table_name VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';

40: l_status VARCHAR2(30);
41: l_industry VARCHAR2(30);
42: l_retstatus BOOLEAN;
43: l_table_owner VARCHAR2(30);
44: l_table_name VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
45: l_update_name VARCHAR2(30) := 'csxacptb.pls'; -- l_update_name will be appended with sysdate, do not make this longer than 18 characters
46: l_start_rowid ROWID;
47: l_end_rowid ROWID;
48: l_any_rows_to_process BOOLEAN;

Line 153: FROM cs_hz_sr_contact_points cp

149: -1,
150: SYSDATE,
151: -1,
152: -1
153: FROM cs_hz_sr_contact_points cp
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'