APPS.OKE_DELIVERABLE_PVT dependencies on PA_FIN_STRUCTURES_LINKS_V

Line 256: FROM pa_fin_structures_links_v

252: WHERE P_ID IN (
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