APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 227: cs_incidents_all_b b,

223: l_user_id csm_item_instances_acc.user_id%TYPE)
224: IS
225: SELECT 1
226: FROM csm_item_instances_acc a,
227: cs_incidents_all_b b,
228: csm_incidents_all_acc c
229: WHERE a.instance_id = l_instance_id
230: AND a.user_id = l_user_id
231: AND a.counter = 1

Line 1032: csm_incidents_all_acc iacc, cs_incidents_all_b cia

1028: p_party_id NUMBER,
1029: p_incident_id NUMBER ) IS
1030: SELECT acc.instance_id
1031: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,
1032: csm_incidents_all_acc iacc, cs_incidents_all_b cia
1033: WHERE acc.instance_id = cii.instance_id
1034: AND acc.user_id = p_user_id
1035: AND acc.counter <> 1 -- do not delete if there is just 1 instance of the IB item
1036: AND acc.instance_id <> p_instance_id