APPS.OKE_DELIVERABLE_PVT dependencies on PA_PROJECTS_ALL

Line 254: FROM pa_projects_all p

250: SELECT 'X'
251: FROM DUAL
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)

Line 261: FROM pa_projects_all

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
262: WHERE Project_ID = P_ID1);
263:
264: CURSOR Seq_C (P_ID NUMBER ) IS
265: SELECT MAX(LEVEL_SEQUENCE)