APPS.CSM_SR_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 721: AND EXISTS(SELECT 1 FROM csm_item_instances_acc acc

717: p_instance_id AS instance_id,
718: cii.inventory_item_id
719: FROM csi_item_instances cii
720: WHERE cii.instance_id = p_instance_id
721: AND EXISTS(SELECT 1 FROM csm_item_instances_acc acc
722: where acc.instance_id =p_instance_id
723: and acc.user_id=p_user_id)
724: -- get the parent instance
725: UNION