DBA Data[Home] [Help]

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 (