DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_AUDIT_B

Line 9057: INSERT INTO cs_incidents_audit_b (

9053: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_audit_id FROM dual;
9054: x_audit_id := l_audit_id;
9055: END IF;
9056:
9057: INSERT INTO cs_incidents_audit_b (
9058: incident_audit_id ,
9059: incident_id ,
9060: last_update_date ,
9061: last_updated_by ,

Line 20646: FROM CS_INCIDENTS_AUDIT_B B

20642: -- This is for the incident_audit_table
20643: DELETE FROM CS_INCIDENTS_AUDIT_TL T
20644: WHERE NOT EXISTS
20645: (SELECT NULL
20646: FROM CS_INCIDENTS_AUDIT_B B
20647: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
20648: );
20649:
20650: UPDATE CS_INCIDENTS_AUDIT_TL T SET (