DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS dependencies on PA_PROJ_ACCUM_MAIN

Line 161: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

157: ORIG_REVENUE_PP = NVL(ORIG_REVENUE_PP,0) +
158: NVL(X_Orig_Revenue_pp,0),
159: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
160: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
161: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 163: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

159: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
160: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
161: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 271: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

267: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
268: ORIG_REVENUE_PTD = ORIG_REVENUE_PTD + X_Orig_Revenue,
269: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
270: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
271: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 273: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

269: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
270: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
271: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 380: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

376: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
377: ORIG_REVENUE_PP = ORIG_REVENUE_PP + X_Orig_Revenue,
378: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
379: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
380: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 382: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

378: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
379: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
380: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 478: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

474: ORIG_REVENUE_ITD = ORIG_REVENUE_ITD + X_Orig_Revenue,
475: ORIG_REVENUE_PP = ORIG_REVENUE_PP + X_Orig_Revenue,
476: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
477: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
478: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 480: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

476: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
477: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
478: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 576: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

572: ORIG_REVENUE_ITD = ORIG_REVENUE_ITD + X_Orig_Revenue,
573: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
574: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
575: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
576: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 578: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

574: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
575: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
576: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 661: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

657: BASE_REVENUE_ITD = BASE_REVENUE_ITD + X_Base_Revenue,
658: ORIG_REVENUE_ITD = ORIG_REVENUE_ITD + X_Orig_Revenue,
659: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
660: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
661: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 663: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

659: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
660: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
661: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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