APPS.PJM_PROJTASK_DELETION dependencies on MRP_SCHEDULE_DATES

Line 113: FROM mrp_schedule_dates schd

109: FROM dual
110: WHERE
111: EXISTS (
112: SELECT 1
113: FROM mrp_schedule_dates schd
114: WHERE schd.project_id = l_project_id
115: AND schd.task_id = NVL(p_task_id, schd.task_id)
116: );
117: CURSOR c8 IS

Line 375: FROM mrp_schedule_dates schd

371: AND frct.organization_id = p_org_id
372: ) OR
373: EXISTS (
374: SELECT 1
375: FROM mrp_schedule_dates schd
376: WHERE schd.project_id = p_project_id
377: AND schd.organization_id = p_org_id
378: ) OR
379: EXISTS (