APPS.PA_PROCESS_ACCUM_BUDGETS dependencies on PA_TASKS

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

165: And PAB.Project_Accum_id In
166: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
167: Where Pah.Project_id = x_project_id and
168: pah.Resource_list_member_id = 0 and
169: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
170: start with pt.task_id = x_task_id
171: connect by prior pt.parent_task_id = pt.task_id)
172: UNION select to_number(X_Proj_accum_id) from sys.dual);
173:

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

275: And PAB.Project_Accum_id In
276: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
277: Where Pah.Project_id = x_project_id and
278: pah.Resource_list_member_id = 0 and
279: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
280: start with pt.task_id = x_task_id
281: connect by prior pt.parent_task_id = pt.task_id)
282: UNION select to_number(X_Proj_accum_id) from sys.dual);
283:

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

384: And PAB.Project_Accum_id In
385: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
386: Where Pah.Project_id = x_project_id and
387: pah.Resource_list_member_id = 0 and
388: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
389: start with pt.task_id = x_task_id
390: connect by prior pt.parent_task_id = pt.task_id)
391: UNION select to_number(X_Proj_accum_id) from sys.dual);
392: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

482: And PAB.Project_Accum_id In
483: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
484: Where Pah.Project_id = x_project_id and
485: pah.Resource_list_member_id = 0 and
486: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
487: start with pt.task_id = x_task_id
488: connect by prior pt.parent_task_id = pt.task_id)
489: UNION select to_number(X_Proj_accum_id) from sys.dual);
490: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

580: And PAB.Project_Accum_id In
581: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
582: Where Pah.Project_id = x_project_id and
583: pah.Resource_list_member_id = 0 and
584: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
585: start with pt.task_id = x_task_id
586: connect by prior pt.parent_task_id = pt.task_id)
587: UNION select to_number(X_Proj_accum_id) from sys.dual);
588: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

665: And PAB.Project_Accum_id In
666: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
667: Where Pah.Project_id = x_project_id and
668: pah.Resource_list_member_id = 0 and
669: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
670: start with pt.task_id = x_task_id
671: connect by prior pt.parent_task_id = pt.task_id)
672: UNION select to_number(X_Proj_accum_id) from sys.dual);
673: Recs_processed := Recs_processed + SQL%ROWCOUNT;