DBA Data[Home] [Help]

APPS.CS_CREATE_AUDIT_REC_PKG dependencies on CS_INCIDENTS_ALL_B

Line 160: FROM CS_INCIDENTS_ALL_B a

156: PRIMARY_CONTACT_ID ,
157: 'N' CHANGE_PRIMARY_CONTACT_FLAG ,
158: NULL OLD_PRIMARY_CONTACT_ID ,
159: SECURITY_GROUP_ID
160: FROM CS_INCIDENTS_ALL_B a
161: WHERE ROWID BETWEEN c_start_rowid AND c_end_rowid
162: AND NOT EXISTS (SELECT b.incident_id
163: FROM cs_incidents_audit_b b
164: WHERE a.incident_id = b.incident_id

Line 317: l_table_name VARCHAR2(30) := 'CS_INCIDENTS_ALL_B';

313: l_create_audit_rec c_sr_current%ROWTYPE;
314:
315: l_worker_id NUMBER;
316: l_product VARCHAR2(30) := 'CS';
317: l_table_name VARCHAR2(30) := 'CS_INCIDENTS_ALL_B';
318: l_table_owner VARCHAR2(30);
319: l_update_name VARCHAR2(30) := 'csxsraucb.pls.115.0';
320: l_start_rowid ROWID;
321: l_end_rowid ROWID;