APPS.PA_PPR_OLAP_CONC_PROGRAM dependencies on PA_OLAP_STAGE

Line 709: insert into PA_OLAP_STAGE(

705: AND b1.version_type IN ( 'ALL' , 'COST' , 'REVENUE')
706: AND bl.budget_version_id = b.budget_version_id;
707: PJI_FM_PLAN_MAINT_PVT.PRORATE_TO_ALL_CALENDARS;
708:
709: insert into PA_OLAP_STAGE(
710: OLAP_GROUP ,
711: PROJECT_ID ,
712: PROJECT_ELEMENT_ID ,
713: TIME_ID ,

Line 865: INSERT INTO pa_olap_stage(

861: p_group_size IN NUMBER) as
862:
863: BEGIN
864:
865: INSERT INTO pa_olap_stage(
866: OLAP_GROUP ,
867: PROJECT_ID ,
868: PROJECT_ELEMENT_ID ,
869: TIME_ID ,

Line 1297: INSERT INTO pa_olap_stage(

1293: pa.pjt_rollup_enabled_flag = 'Y'
1294: ) tmp1, pa_projects_all p
1295: where tmp1.project_id = p.project_id;
1296:
1297: INSERT INTO pa_olap_stage(
1298: OLAP_GROUP ,
1299: PROJECT_ID ,
1300: PROJECT_ELEMENT_ID ,
1301: TIME_ID ,

Line 1753: INSERT INTO pa_olap_stage(

1749:
1750: BEGIN
1751:
1752:
1753: INSERT INTO pa_olap_stage(
1754: OLAP_GROUP ,
1755: PROJECT_ID ,
1756: PROJECT_ELEMENT_ID ,
1757: TIME_ID ,

Line 2189: INSERT INTO pa_olap_stage(

2185: pa.project_currency_code <> pa.projfunc_currency_code
2186: ) tmp1, pa_projects_all p
2187: where tmp1.project_id = p.project_id;
2188:
2189: INSERT INTO pa_olap_stage(
2190: OLAP_GROUP ,
2191: PROJECT_ID ,
2192: PROJECT_ELEMENT_ID ,
2193: TIME_ID ,

Line 3045: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');

3041: PA_olap_PVT.generate_nev('PA_TASK_OLAP_V');
3042: PA_olap_PVT.generate_nev('PA_RBS_VERSIONS_OLAP_V');
3043: PA_olap_PVT.generate_nev('PA_RBS_ELEMENTS_OLAP_V');
3044: PA_olap_PVT.generate_nev('PA_PROJECT_OLAP_V');
3045: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');
3046: PA_olap_PVT.generate_nev('PA_CURRENCY_OLAP_V');
3047: PA_olap_PVT.generate_nev('PA_CBS_VERSIONS_OLAP_V');
3048: PA_olap_PVT.generate_nev('PA_CBS_ELEMENTS_OLAP_V');
3049: PA_olap_PVT.generate_nev('PA_CALENDAR_TYPE_OLAP_V');

Line 3064: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');

3060: PA_olap_PVT.generate_nev('PA_TASK_OLAP_V');
3061: PA_olap_PVT.generate_nev('PA_RBS_VERSIONS_OLAP_V');
3062: PA_olap_PVT.generate_nev('PA_RBS_ELEMENTS_OLAP_V');
3063: PA_olap_PVT.generate_nev('PA_PROJECT_OLAP_V');
3064: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');
3065: PA_olap_PVT.generate_nev('PA_CURRENCY_OLAP_V');
3066: PA_olap_PVT.generate_nev('PA_CBS_VERSIONS_OLAP_V');
3067: PA_olap_PVT.generate_nev('PA_CBS_ELEMENTS_OLAP_V');
3068: PA_olap_PVT.generate_nev('PA_CALENDAR_TYPE_OLAP_V');

Line 3088: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');

3084: PA_olap_PVT.generate_nev('PA_TASK_OLAP_V');
3085: PA_olap_PVT.generate_nev('PA_RBS_VERSIONS_OLAP_V');
3086: PA_olap_PVT.generate_nev('PA_RBS_ELEMENTS_OLAP_V');
3087: PA_olap_PVT.generate_nev('PA_PROJECT_OLAP_V');
3088: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');
3089: PA_olap_PVT.generate_nev('PA_CURRENCY_OLAP_V');
3090: PA_olap_PVT.generate_nev('PA_CBS_VERSIONS_OLAP_V');
3091: PA_olap_PVT.generate_nev('PA_CBS_ELEMENTS_OLAP_V');
3092: PA_olap_PVT.generate_nev('PA_CALENDAR_TYPE_OLAP_V');

Line 3107: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');

3103: PA_olap_PVT.generate_nev('PA_TASK_OLAP_V');
3104: PA_olap_PVT.generate_nev('PA_RBS_VERSIONS_OLAP_V');
3105: PA_olap_PVT.generate_nev('PA_RBS_ELEMENTS_OLAP_V');
3106: PA_olap_PVT.generate_nev('PA_PROJECT_OLAP_V');
3107: PA_olap_PVT.generate_nev('PA_OLAP_STAGE_V');
3108: PA_olap_PVT.generate_nev('PA_CURRENCY_OLAP_V');
3109: PA_olap_PVT.generate_nev('PA_CBS_VERSIONS_OLAP_V');
3110: PA_olap_PVT.generate_nev('PA_CBS_ELEMENTS_OLAP_V');
3111: PA_olap_PVT.generate_nev('PA_CALENDAR_TYPE_OLAP_V');