DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS dependencies on PA_PROJECT_ACCUM_HEADERS

Line 166: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

162: LAST_UPDATE_DATE = Trunc(Sysdate),
163: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
164: Where Budget_Type_Code = x_Budget_type_code
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

Line 276: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

272: LAST_UPDATE_DATE = Trunc(Sysdate),
273: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
274: Where Budget_Type_Code = x_Budget_type_code
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

Line 385: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

381: LAST_UPDATE_DATE = Trunc(Sysdate),
382: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
383: Where Budget_Type_Code = x_Budget_type_code
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

Line 483: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

479: LAST_UPDATE_DATE = Trunc(Sysdate),
480: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
481: Where Budget_Type_Code = x_Budget_type_code
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

Line 581: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

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

Line 666: (Select Pah.Project_Accum_id from PA_PROJECT_ACCUM_HEADERS PAH

662: LAST_UPDATE_DATE = Trunc(Sysdate),
663: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login
664: Where Budget_Type_Code = x_Budget_type_code
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