APPS.PA_MAINT_PROJECT_BUDGETS dependencies on PA_TASKS

Line 1336: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt

1332: (PAB.Project_Accum_id In
1333: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1334: Where Pah.Project_id = x_project_id and
1335: pah.Resource_list_member_id = 0 and
1336: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
1337: start with pt.task_id = x_budget_rec.TASK_ID
1338: connect by prior pt.parent_task_id = pt.task_id)
1339: UNION
1340: select to_number(X_Proj_accum_id) from sys.dual

Line 1347: Select Pt.Task_Id from PA_TASKS pt

1343: Where Pah.Project_id = x_project_id and
1344: pah.Resource_list_member_id =
1345: x_Budget_rec.RESOURCE_LIST_MEMBER_ID and
1346: Pah.Task_id in (select 0 from sys.dual union
1347: Select Pt.Task_Id from PA_TASKS pt
1348: start with pt.task_id = x_budget_rec.TASK_ID
1349: connect by prior pt.parent_task_id = pt.task_id)))
1350: );
1351: tot_Recs_processed := tot_Recs_processed + SQL%ROWCOUNT;

Line 1763: pa_tasks pt

1759:
1760: CURSOR Tasks_Cur IS
1761: SELECT task_id
1762: FROM
1763: pa_tasks pt
1764: WHERE project_id = x_project_id
1765: START WITH task_id = x_task_id
1766: CONNECT BY PRIOR parent_task_id = task_id;
1767: