APPS.OKE_BILLING_EVENT_PUB dependencies on PA_FIN_STRUCTURES_LINKS_V

Line 275: FROM pa_fin_structures_links_v

271: WHERE P_ID IN (
272: SELECT P.Project_ID
273: FROM pa_projects_all p
274: WHERE p.Project_ID IN (SELECT To_Number(sub_project_id)
275: FROM pa_fin_structures_links_v
276: 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)
277: CONNECT BY parent_project_id = PRIOR sub_project_id)
278: UNION
279: SELECT Project_ID