DBA Data[Home] [Help]

APPS.CS_SERVICEREQUEST_PVT dependencies on CS_INCIDENTS_AUDIT_B

Line 8115: INSERT INTO cs_incidents_audit_b (

8111: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_audit_id FROM dual;
8112: x_audit_id := l_audit_id;
8113: END IF;
8114:
8115: INSERT INTO cs_incidents_audit_b (
8116: incident_audit_id ,
8117: incident_id ,
8118: last_update_date ,
8119: last_updated_by ,

Line 19130: FROM CS_INCIDENTS_AUDIT_B B

19126: -- This is for the incident_audit_table
19127: DELETE FROM CS_INCIDENTS_AUDIT_TL T
19128: WHERE NOT EXISTS
19129: (SELECT NULL
19130: FROM CS_INCIDENTS_AUDIT_B B
19131: WHERE B.INCIDENT_AUDIT_ID = T.INCIDENT_AUDIT_ID
19132: );
19133:
19134: UPDATE CS_INCIDENTS_AUDIT_TL T SET (