APPS.PA_PROCESS_ACCUM_CMT_RES dependencies on PA_TASKS

Line 123: Select Pt.Task_Id from PA_TASKS pt

119: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
120: Where Pah.Project_id = x_project_id and
121: pah.Resource_list_member_id = x_resource_list_Member_id and
122: Pah.Task_id in ( select 0 from sys.dual union
123: Select Pt.Task_Id from PA_TASKS pt
124: start with pt.task_id = x_task_id
125: connect by prior pt.parent_task_id = pt.task_id));
126: Recs_processed := Recs_processed + SQL%ROWCOUNT;
127:

Line 366: Select Pt.Task_Id from PA_TASKS pt

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 = x_resource_list_Member_id and
365: Pah.Task_id in (select 0 from sys.dual union
366: Select Pt.Task_Id from PA_TASKS pt
367: start with pt.task_id = x_task_id
368: connect by prior pt.parent_task_id = pt.task_id));
369: Recs_processed := Recs_processed + SQL%ROWCOUNT;
370:

Line 610: Select Pt.Task_Id from PA_TASKS pt

606: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
607: Where Pah.Project_id = x_project_id and
608: pah.Resource_list_member_id = x_resource_list_Member_id and
609: Pah.Task_id in (select 0 from sys.dual union
610: Select Pt.Task_Id from PA_TASKS pt
611: start with pt.task_id = x_task_id
612: connect by prior pt.parent_task_id = pt.task_id));
613: Recs_processed := Recs_processed + SQL%ROWCOUNT;
614: v_noof_tasks := 0;

Line 853: Select Pt.Task_Id from PA_TASKS pt

849: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
850: Where Pah.Project_id = x_project_id and
851: pah.Resource_list_member_id = x_resource_list_Member_id and
852: Pah.Task_id in (select 0 from sys.dual union
853: Select Pt.Task_Id from PA_TASKS pt
854: start with pt.task_id = x_task_id
855: connect by prior pt.parent_task_id = pt.task_id));
856: Recs_processed := Recs_processed + SQL%ROWCOUNT;
857:

Line 1090: Select Pt.Task_Id from PA_TASKS pt

1086: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
1087: Where Pah.Project_id = x_project_id and
1088: pah.Resource_list_member_id = x_resource_list_Member_id and
1089: Pah.Task_id in (select 0 from sys.dual union
1090: Select Pt.Task_Id from PA_TASKS pt
1091: start with pt.task_id = x_task_id
1092: connect by prior pt.parent_task_id = pt.task_id));
1093: Recs_processed := Recs_processed + SQL%ROWCOUNT;
1094:

Line 1228: FROM pa_tasks pt

1224: -- (Tasks with the given Resource )
1225:
1226: CURSOR Tasks_Cur IS
1227: SELECT task_id
1228: FROM pa_tasks pt
1229: WHERE project_id = x_project_id
1230: AND NOT EXISTS
1231: (SELECT 'x'
1232: FROM