APPS.PJM_PROJTASK_DELETION dependencies on OE_ORDER_LINES_ALL

Line 63: FROM oe_order_lines_all ool

59: FROM dual
60: WHERE
61: EXISTS (
62: SELECT 1
63: FROM oe_order_lines_all ool
64: WHERE ool.project_id = l_project_id
65: AND ool.task_id = NVL(p_task_id, ool.task_id)
66: );
67: CURSOR c3 IS

Line 338: FROM oe_order_lines_all ool

334: FROM dual
335: WHERE
336: EXISTS (
337: SELECT 1
338: FROM oe_order_lines_all ool
339: WHERE ool.project_id = p_project_id
340: AND ool.ship_from_org_id = p_org_id
341: ) OR
342: EXISTS (