APPS.CSM_ITEM_INSTANCE_EVENT_PKG dependencies on CS_INCIDENTS_ALL_B

Line 226: cs_incidents_all_b b,

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

Line 1073: csm_incidents_all_acc iacc, cs_incidents_all_b cia

1069: p_party_id NUMBER,
1070: p_incident_id NUMBER ) IS
1071: SELECT acc.instance_id
1072: FROM CSM_ITEM_INSTANCES_ACC acc, CSI_ITEM_INSTANCES cii,
1073: csm_incidents_all_acc iacc, cs_incidents_all_b cia
1074: WHERE acc.instance_id = cii.instance_id
1075: AND acc.user_id = p_user_id
1076: AND acc.counter <> 1 -- do not delete if there is just 1 instance of the IB item
1077: AND acc.instance_id <> p_instance_id