APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PJI_TIME_CAL_PERIOD

Line 188: INSERT INTO pji_time_cal_period

184: AND bv.fin_plan_type_id <> 10 /* Added for bug 8708651*/
185: AND fpo.fin_plan_option_level_code = 'PLAN_VERSION' -- Other values are: plan type and project.
186: AND bv.version_type IN ( 'ALL' , 'COST' , 'REVENUE');
187:
188: INSERT INTO pji_time_cal_period
189: (
190: CAL_PERIOD_ID,
191: CAL_QTR_ID,
192: CALENDAR_ID,

Line 431: pji_time_cal_period per,

427: pa_budget_versions_olap_tmp2 b ,
428: pa_budget_versions b1,
429: pa_resource_assignments ra,
430: pa_budget_lines bl,
431: pji_time_cal_period per,
432: pa_projects_all p1,
433: pa_proj_fp_options fpo,
434: PJI_ORG_EXTR_INFO inf
435: where

Line 677: pji_time_cal_period per,

673: pa_budget_versions_olap_tmp2 b ,
674: pa_budget_versions b1,
675: pa_resource_assignments ra,
676: pa_budget_lines bl,
677: pji_time_cal_period per,
678: pa_projects_all p1,
679: pa_proj_fp_options fpo,
680: PJI_ORG_EXTR_INFO inf
681: where

Line 856: delete from pji_time_cal_period where cal_period_id = -1;

852: -1
853: from pji_fp_aggr_pjp1 bv, pa_projects_all p
854: where bv.project_id = p.project_id;
855:
856: delete from pji_time_cal_period where cal_period_id = -1;
857:
858: END maintain_budgets;
859:
860: Procedure maintain_actuals_prj (