APPS.PJM_PROJTASK_DELETION dependencies on MTL_ITEM_LOCATIONS
Line 83: FROM mtl_item_locations loc
79: FROM dual
80: WHERE
81: EXISTS (
82: SELECT 1 83: FROM mtl_item_locations loc 84: WHERE loc.project_id = l_project_id
85: AND loc.task_id = NVL(p_task_id, loc.task_id)
86: );
87: CURSOR c5 IS
Line 350: FROM mtl_item_locations loc
346: AND job.organization_id = p_org_id
347: ) OR
348: EXISTS (
349: SELECT 1 350: FROM mtl_item_locations loc 351: WHERE loc.project_id = p_project_id
352: AND loc.organization_id = p_org_id
353: ) OR
354: EXISTS (