APPS.PA_PROCESS_ACCUM_BUDGETS_RES dependencies on PA_PROJECT_ACCUM_HEADERS

Line 205: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

201: LAST_UPDATE_DATE = Trunc(Sysdate),
202: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
203: Where Budget_Type_Code = x_Budget_type_code
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

Line 334: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

330: LAST_UPDATE_DATE = Trunc(Sysdate),
331: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
332: Where Budget_Type_Code = x_Budget_type_code
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

Line 462: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

458: LAST_UPDATE_DATE = Trunc(Sysdate),
459: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
460: Where Budget_Type_Code = x_Budget_type_code
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

Line 580: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

576: LAST_UPDATE_DATE = Trunc(Sysdate),
577: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
578: Where Budget_Type_Code = x_Budget_type_code
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

Line 697: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

693: LAST_UPDATE_DATE = Trunc(Sysdate),
694: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
695: Where Budget_Type_Code = x_Budget_type_code
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

Line 802: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

798: LAST_UPDATE_DATE = Trunc(Sysdate),
799: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
800: Where Budget_Type_Code = x_Budget_type_code
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