DBA Data[Home] [Help]

APPS.CSM_PARTY_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 126: CS_INCIDENTS_ALL_B csi

122: AND NOT EXISTS
123: (
124: SELECT 1
125: FROM csm_incidents_all_acc acc,
126: CS_INCIDENTS_ALL_B csi
127: WHERE acc.incident_id = csi.incident_id
128: AND acc.user_id = p.user_id
129: AND csi.customer_id = p.party_id
130: )

Line 308: CS_INCIDENTS_ALL_B csi

304: WHERE NOT EXISTS
305: (
306: SELECT /*+INDEX (csi CS_INCIDENTS_U1) */ 1
307: FROM csm_incidents_all_acc acc,
308: CS_INCIDENTS_ALL_B csi
309: WHERE acc.incident_id = csi.incident_id
310: AND acc.user_id=p.user_id
311: AND csi.customer_id=p.party_id
312: )