DBA Data[Home] [Help]

APPS.CS_AUDIT_UPGRADE_CON_PRG dependencies on CS_INCIDENTS_ALL_B

Line 173: FROM CS_INCIDENTS_ALL_B

169: PRIMARY_CONTACT_ID ,
170: 'N' CHANGE_PRIMARY_CONTACT_FLAG ,
171: to_number(NULL) OLD_PRIMARY_CONTACT_ID ,
172: SECURITY_GROUP_ID
173: FROM CS_INCIDENTS_ALL_B
174: WHERE ROWID BETWEEN c_start_rowid AND c_end_rowid
175: AND creation_date > p_audit_date;
176:
177: CURSOR c_sr_audit(c_incident_id number) IS

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

555: l_audit_date DATE;
556:
557: l_worker_id NUMBER;
558: l_product VARCHAR2(30) := 'CS';
559: l_table_name VARCHAR2(30) := 'CS_INCIDENTS_ALL_B';
560: l_table_owner VARCHAR2(30);
561: l_update_name VARCHAR2(30) := 'csxaucpb.pls'; -- l_update_name will be appended with sysdate, do not make this longer than 18 characters
562: l_start_rowid ROWID;
563: l_end_rowid ROWID;