APPS.OKE_DELIVERABLE_PVT dependencies on PA_TASKS

Line 257: START WITH parent_project_id = P_ID1 AND (parent_task_id IN (SELECT Task_ID FROM pa_tasks WHERE Top_Task_ID = P_ID2) or P_ID2 IS NULL)

253: SELECT P.Project_ID
254: FROM pa_projects_all p
255: WHERE p.Project_ID IN (SELECT To_Number(sub_project_id)
256: FROM pa_fin_structures_links_v
257: START WITH parent_project_id = P_ID1 AND (parent_task_id IN (SELECT Task_ID FROM pa_tasks WHERE Top_Task_ID = P_ID2) or P_ID2 IS NULL)
258: CONNECT BY parent_project_id = PRIOR sub_project_id)
259: UNION
260: SELECT Project_ID
261: FROM pa_projects_all

Line 364: FROM pa_tasks

360: L_Value VARCHAR2(1) := 'N';
361:
362: CURSOR C (P_ID1 NUMBER, P_ID2 NUMBER) IS
363: SELECT 'X'
364: FROM pa_tasks
365: WHERE Task_ID = P_ID1
366: AND Project_ID = P_ID2;
367:
368: Begin