APPS.CS_SERVICE_AVAIL_PKG dependencies on CS_SERVICE_AVAILABILITY
Line 20: FROM cs_service_availability
16: p_service_avail_id IN NUMBER,
17: p_exists_flag IN OUT VARCHAR2) IS
18: CURSOR Check_Exists IS
19: SELECT 'x' 20: FROM cs_service_availability 21: WHERE Service_Inventory_Item_Id = p_service_inv_item_id
22: AND nvl(Inventory_Item_Id, -1) = nvl(p_avail_inv_item_id, -1)
23: AND nvl(Item_Manufacturing_Org_Id, -1) = nvl(p_manu_org_id, -1)
24: AND nvl(Customer_Id, -1) = nvl(p_customer_id, -1)