APPS.PA_PROCESS_ACCUM_COMMITMENTS dependencies on PA_TASKS

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

72: Where PAA.Project_Accum_id In
73: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
74: Where Pah.Project_id = x_project_id and
75: pah.Resource_list_member_id = 0 and
76: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
77: start with pt.task_id = x_task_id
78: connect by prior pt.parent_task_id = pt.task_id)
79: UNION select to_number(X_Proj_accum_id) from sys.dual );
80: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

221: Where PAA.Project_Accum_id In
222: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
223: Where Pah.Project_id = x_project_id and
224: pah.Resource_list_member_id = 0 and
225: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
226: start with pt.task_id = x_task_id
227: connect by prior pt.parent_task_id = pt.task_id)
228: UNION select to_number(X_Proj_accum_id) from sys.dual );
229: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

361: Where PAA.Project_Accum_id In
362: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
363: Where Pah.Project_id = x_project_id and
364: pah.Resource_list_member_id = 0 and
365: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
366: start with pt.task_id = x_task_id
367: connect by prior pt.parent_task_id = pt.task_id)
368: UNION select to_number(X_Proj_accum_id) from sys.dual );
369: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

507: Where PAA.Project_Accum_id In
508: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
509: Where Pah.Project_id = x_project_id and
510: pah.Resource_list_member_id = 0 and
511: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
512: start with pt.task_id = x_task_id
513: connect by prior pt.parent_task_id = pt.task_id)
514: UNION select to_number(X_Proj_accum_id) from sys.dual );
515: Recs_processed := Recs_processed + SQL%ROWCOUNT;

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

651: Where PAA.Project_Accum_id In
652: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
653: Where Pah.Project_id = x_project_id and
654: pah.Resource_list_member_id = 0 and
655: Pah.Task_id in (Select Pt.Task_Id from PA_TASKS pt
656: start with pt.task_id = x_task_id
657: connect by prior pt.parent_task_id = pt.task_id)
658: UNION select to_number(X_Proj_accum_id) from sys.dual );
659: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 742: -- This procedure returns all those tasks from PA_TASKS, which do not

738: x_err_stage In Out NOCOPY Varchar2, --File.Sql.39 bug 4440895
739: x_err_code In Out NOCOPY Number ) IS --File.Sql.39 bug 4440895
740:
741:
742: -- This procedure returns all those tasks from PA_TASKS, which do not
743: -- have a record in PA_PROJECT_ACCUM_HEADERS table, with Resource_List_member_id
744: -- (Project-task level numbers without resources )
745:
746: CURSOR Tasks_Cur IS

Line 748: FROM pa_tasks pt

744: -- (Project-task level numbers without resources )
745:
746: CURSOR Tasks_Cur IS
747: SELECT task_id
748: FROM pa_tasks pt
749: WHERE project_id = x_project_id
750: AND NOT EXISTS
751: (SELECT 'x'
752: FROM