APPS.PJI_FM_PLAN_EXTR dependencies on PJI_FM_EXTR_PLNVER1

Line 193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);

189:
190: pji_utils.write2log('Entering PJI_FM_PLAN_EXTR.CLEANUP',TRUE, 3);
191:
192:
193: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER1', 'NORMAL',null);
194: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLAN', 'NORMAL',null);
195: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_EXTR_PLNVER2', 'NORMAL',null);
196: PJI_PROCESS_UTIL.TRUNC_INT_TABLE( pji_utils.get_pji_schema_name , 'PJI_FM_AGGR_PLN', 'NORMAL',null);
197:

Line 315: Insert into PJI_FM_EXTR_PLNVER1

311: end if;
312:
313: -- Get Financial Plan versions
314:
315: Insert into PJI_FM_EXTR_PLNVER1
316: ( WORKER_ID
317: , PROJECT_ID
318: , PROJECT_ORGANIZATION_ID
319: , PROJECT_ORG_ID

Line 390: Insert /*+ APPEND */ into PJI_FM_EXTR_PLNVER1

386: ;
387:
388: -- Get budget versions for those projects without Financial Plans
389:
390: Insert /*+ APPEND */ into PJI_FM_EXTR_PLNVER1
391: ( WORKER_ID
392: , PROJECT_ID
393: , PROJECT_ORGANIZATION_ID
394: , PROJECT_ORG_ID

Line 427: from PJI_FM_EXTR_PLNVER1

423: , pa_budget_versions bv
424: , pa_budget_entry_methods bem
425: , (select distinct
426: PROJECT_ID
427: from PJI_FM_EXTR_PLNVER1
428: where WORKER_ID = p_worker_id) pln
429: Where 1=1
430: and map.worker_id = p_worker_id
431: and map.project_id = bv.project_id

Line 497: , tabname => 'PJI_FM_EXTR_PLNVER1'

493: if (PJI_PROCESS_UTIL.GET_PROCESS_PARAMETER(l_process,
494: 'CURRENT_BATCH') = 1) then
495: FND_STATS.GATHER_TABLE_STATS(
496: ownname => pji_utils.get_pji_schema_name
497: , tabname => 'PJI_FM_EXTR_PLNVER1'
498: , percent => 10
499: , degree => l_degree
500: );
501: end if;

Line 628: , PJI_FM_EXTR_PLNVER1 vers

624: , null rate_dangling_flag
625: , null rate2_dangling_flag
626: from
627: PJI_ORG_EXTR_INFO orginfo
628: , PJI_FM_EXTR_PLNVER1 vers
629: , pa_resource_assignments ra
630: , pa_budget_lines bl
631: , ( select -1 calendar_id
632: , -1 period_id

Line 2189: PJI_FM_EXTR_PLNVER1 vers,

2185: 'Y', tmp.labor_hrs,
2186: to_number(null)),
2187: to_number(null))) curr_forecast_labor_hrs
2188: from
2189: PJI_FM_EXTR_PLNVER1 vers,
2190: PJI_FM_EXTR_PLAN tmp,
2191: PJI_FM_EXTR_PLN_LOG log
2192: where
2193: tmp.WORKER_ID = p_worker_id and

Line 2350: PJI_FM_EXTR_PLNVER1 bvs,

2346: else 0
2347: end REVENUE_FORECAST_C_VERSION
2348: from
2349: PJI_PJI_PROJ_BATCH_MAP map,
2350: PJI_FM_EXTR_PLNVER1 bvs,
2351: PJI_FM_EXTR_PLAN tmp,
2352: PJI_FM_EXTR_PLN_LOG log
2353: where
2354: map.worker_id = p_worker_id