APPS.PJM_PROJTASK_DELETION dependencies on WIP_DISCRETE_JOBS

Line 73: FROM wip_discrete_jobs job

69: FROM dual
70: WHERE
71: EXISTS (
72: SELECT 1
73: FROM wip_discrete_jobs job
74: WHERE job.project_id = l_project_id
75: AND job.task_id = NVL(p_task_id, job.task_id)
76: );
77: CURSOR c4 IS

Line 344: FROM wip_discrete_jobs job

340: AND ool.ship_from_org_id = p_org_id
341: ) OR
342: EXISTS (
343: SELECT 1
344: FROM wip_discrete_jobs job
345: WHERE job.project_id = p_project_id
346: AND job.organization_id = p_org_id
347: ) OR
348: EXISTS (