APPS.PJI_FM_PLAN_EXTR dependencies on PJI_PJI_PROJ_BATCH_MAP

Line 348: PJI_PJI_PROJ_BATCH_MAP map

344: , bv.current_original_flag current_original_flag
345: , null dangling_flag
346: , map.project_type_class project_type_class
347: From
348: PJI_PJI_PROJ_BATCH_MAP map
349: , pa_budget_versions bv
350: , pa_proj_fp_options fpo
351: Where 1=1
352: and map.worker_id = p_worker_id

Line 422: PJI_PJI_PROJ_BATCH_MAP map

418: , bv.current_original_flag current_original_flag
419: , null dangling_flag
420: , map.project_type_class project_type_class
421: From
422: PJI_PJI_PROJ_BATCH_MAP map
423: , pa_budget_versions bv
424: , pa_budget_entry_methods bem
425: , (select distinct
426: PROJECT_ID

Line 2349: PJI_PJI_PROJ_BATCH_MAP map,

2345: then bvs.VERSION_ID
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

Line 2480: update pji_pji_proj_batch_map map

2476: if (sql%rowcount <> 0) then
2477:
2478: commit;
2479:
2480: update pji_pji_proj_batch_map map
2481: set (map.COST_BUDGET_N_VERSION,
2482: map.COST_BUDGET_NO_VERSION,
2483: map.REVENUE_BUDGET_N_VERSION,
2484: map.REVENUE_BUDGET_NO_VERSION,

Line 2650: (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */

2646: REVENUE_BUDGET_C_VERSION,
2647: REVENUE_BUDGET_CO_VERSION,
2648: COST_FORECAST_C_VERSION,
2649: REVENUE_FORECAST_C_VERSION) =
2650: (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
2651: map.NEW_CLOSED_DATE,
2652: map.NEW_PROJECT_ORGANIZATION_ID,
2653: nvl(map.COST_BUDGET_N_VERSION,status.COST_BUDGET_C_VERSION),
2654: nvl(map.COST_BUDGET_NO_VERSION,status.COST_BUDGET_CO_VERSION),

Line 2659: from PJI_PJI_PROJ_BATCH_MAP map

2655: nvl(map.REVENUE_BUDGET_N_VERSION,status.REVENUE_BUDGET_C_VERSION),
2656: nvl(map.REVENUE_BUDGET_NO_VERSION,status.REVENUE_BUDGET_CO_VERSION),
2657: nvl(map.COST_FORECAST_N_VERSION,status.COST_FORECAST_C_VERSION),
2658: nvl(map.REVENUE_FORECAST_N_VERSION,status.REVENUE_FORECAST_C_VERSION)
2659: from PJI_PJI_PROJ_BATCH_MAP map
2660: where map.WORKER_ID = p_worker_id and
2661: map.PROJECT_ID = status.PROJECT_ID)
2662: where PROJECT_ID in (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
2663: PROJECT_ID

Line 2662: where PROJECT_ID in (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */

2658: nvl(map.REVENUE_FORECAST_N_VERSION,status.REVENUE_FORECAST_C_VERSION)
2659: from PJI_PJI_PROJ_BATCH_MAP map
2660: where map.WORKER_ID = p_worker_id and
2661: map.PROJECT_ID = status.PROJECT_ID)
2662: where PROJECT_ID in (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
2663: PROJECT_ID
2664: from PJI_PJI_PROJ_BATCH_MAP
2665: where WORKER_ID = p_worker_id);
2666:

Line 2664: from PJI_PJI_PROJ_BATCH_MAP

2660: where map.WORKER_ID = p_worker_id and
2661: map.PROJECT_ID = status.PROJECT_ID)
2662: where PROJECT_ID in (select /*+ index(map, PJI_PJI_PROJ_BATCH_MAP_N1) */
2663: PROJECT_ID
2664: from PJI_PJI_PROJ_BATCH_MAP
2665: where WORKER_ID = p_worker_id);
2666:
2667: PJI_PROCESS_UTIL.REGISTER_STEP_COMPLETION
2668: (