APPS.OKE_BILLING_EVENT_PUB dependencies on PA_TASKS

Line 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)

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
280: FROM pa_projects_all

Line 383: FROM pa_tasks

379: L_Value VARCHAR2(1) := 'N';
380:
381: CURSOR C (P_ID1 NUMBER, P_ID2 NUMBER) IS
382: SELECT 'X'
383: FROM pa_tasks
384: WHERE Task_ID = P_ID1
385: AND Project_ID = P_ID2;
386:
387: Begin