DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS_RES dependencies on DUAL

Line 208: Pah.Task_id in (select 0 from sys.dual union

204: And (PAB.Project_Accum_id In
205: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
206: Where Pah.Project_id = x_project_id and
207: pah.Resource_list_member_id = x_resource_list_member_id and
208: Pah.Task_id in (select 0 from sys.dual union
209: Select Pt.Task_Id from PA_TASKS pt
210: start with pt.task_id = x_task_id
211: connect by prior pt.parent_task_id = pt.task_id))) ;
212:

Line 337: Pah.Task_id in (select 0 from sys.dual union

333: And (PAB.Project_Accum_id In
334: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
335: Where Pah.Project_id = x_project_id and
336: pah.Resource_list_member_id = x_resource_list_member_id and
337: Pah.Task_id in (select 0 from sys.dual union
338: Select Pt.Task_Id from PA_TASKS pt
339: start with pt.task_id = x_task_id
340: connect by prior pt.parent_task_id = pt.task_id))) ;
341:

Line 465: Pah.Task_id in (select 0 from sys.dual union

461: And (PAB.Project_Accum_id In
462: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
463: Where Pah.Project_id = x_project_id and
464: pah.Resource_list_member_id = x_resource_list_member_id and
465: Pah.Task_id in (select 0 from sys.dual union
466: Select Pt.Task_Id from PA_TASKS pt
467: start with pt.task_id = x_task_id
468: connect by prior pt.parent_task_id = pt.task_id))) ;
469: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 583: Pah.Task_id in (select 0 from sys.dual union

579: And (PAB.Project_Accum_id In
580: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
581: Where Pah.Project_id = x_project_id and
582: pah.Resource_list_member_id = x_resource_list_member_id and
583: Pah.Task_id in (select 0 from sys.dual union
584: 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: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 700: Pah.Task_id in (select 0 from sys.dual union

696: And (PAB.Project_Accum_id In
697: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
698: Where Pah.Project_id = x_project_id and
699: pah.Resource_list_member_id = x_resource_list_member_id and
700: Pah.Task_id in (select 0 from sys.dual union
701: Select Pt.Task_Id from PA_TASKS pt
702: start with pt.task_id = x_task_id
703: connect by prior pt.parent_task_id = pt.task_id))) ;
704: Recs_processed := Recs_processed + SQL%ROWCOUNT;

Line 805: Pah.Task_id in (select 0 from sys.dual union

801: And (PAB.Project_Accum_id In
802: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH
803: Where Pah.Project_id = x_project_id and
804: pah.Resource_list_member_id = x_resource_list_member_id and
805: Pah.Task_id in (select 0 from sys.dual union
806: Select Pt.Task_Id from PA_TASKS pt
807: start with pt.task_id = x_task_id
808: connect by prior pt.parent_task_id = pt.task_id))) ;
809: Recs_processed := Recs_processed + SQL%ROWCOUNT;