APPS.CSF_DEBRIEF_PVT dependencies on CSP_SEC_INVENTORIES

Line 3497: from csp_sec_inventories csi

3493: where cpp.stocking_site_type = 'TECHNICIAN'
3494: and (cpp.organization_id,cpp.secondary_inventory) in
3495: (select csi.organization_id,
3496: csi.secondary_inventory_name
3497: from csp_sec_inventories csi
3498: where csi.owner_resource_type = l_resource_type_code
3499: and csi.owner_resource_id = l_resource_id);
3500: else
3501: open c_any_working_task;

Line 3524: from csp_sec_inventories csi

3520: where cpp.stocking_site_type = 'TECHNICIAN'
3521: and (cpp.organization_id,cpp.secondary_inventory) in
3522: (select csi.organization_id,
3523: csi.secondary_inventory_name
3524: from csp_sec_inventories csi
3525: where csi.owner_resource_type = l_resource_type_code
3526: and csi.owner_resource_id = l_resource_id);
3527: end if;
3528: end if;