DBA Data[Home] [Help]

APPS.PA_PROCESS_ACCUM_BUDGETS_RES dependencies on PA_PROJ_ACCUM_MAIN

Line 200: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

196: ORIG_REVENUE_PP = NVL(ORIG_REVENUE_PP,0) +
197: NVL(X_Orig_Revenue_pp,0),
198: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
199: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
200: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 202: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

198: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
199: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
200: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 329: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

325: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
326: ORIG_REVENUE_PTD = ORIG_REVENUE_PTD + X_Orig_Revenue,
327: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
328: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
329: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 331: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

327: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
328: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
329: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 457: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

453: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
454: ORIG_REVENUE_PP = ORIG_REVENUE_PP + X_Orig_Revenue,
455: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
456: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
457: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 459: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

455: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
456: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
457: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 575: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

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

Line 577: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

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

Line 692: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

688: ORIG_REVENUE_ITD = ORIG_REVENUE_ITD + X_Orig_Revenue,
689: ORIG_REVENUE_YTD = ORIG_REVENUE_YTD + X_Orig_Revenue,
690: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
691: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
692: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 694: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

690: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
691: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
692: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 797: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,

793: BASE_REVENUE_ITD = BASE_REVENUE_ITD + X_Base_Revenue,
794: ORIG_REVENUE_ITD = ORIG_REVENUE_ITD + X_Orig_Revenue,
795: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
796: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
797: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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

Line 799: LAST_UPDATE_LOGIN = pa_proj_accum_main.x_last_update_login

795: BASE_UNIT_OF_MEASURE = X_Base_Unit_of_Measure,
796: ORIG_UNIT_OF_MEASURE = X_Orig_Unit_of_Measure,
797: LAST_UPDATED_BY = pa_proj_accum_main.x_last_updated_by,
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