APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on PJI_AC_AGGR_PJP1_T

Line 2309: INSERT INTO pji_ac_aggr_pjp1_t

2305: BEGIN
2306:
2307: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2308:
2309: INSERT INTO pji_ac_aggr_pjp1_t
2310: (
2311: WORKER_ID
2312: , PROJECT_ID
2313: , PROJECT_ORG_ID

Line 2451: pji_ac_aggr_pjp1_t fact1

2447: , SUM(fact1.CUSTOM14)
2448: , SUM(fact1.CUSTOM15)
2449: , g_default_prg_level prg_level
2450: FROM
2451: pji_ac_aggr_pjp1_t fact1
2452: , pji_time_CAL_PERIOD period
2453: , pji_time_CAL_QTR qtr
2454: WHERE
2455: fact1.calendar_type = 'P'

Line 2492: INSERT INTO pji_ac_aggr_pjp1_t

2488: BEGIN
2489:
2490: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2491:
2492: INSERT INTO pji_ac_aggr_pjp1_t
2493: (
2494: worker_id
2495: , PROJECT_ID
2496: , PROJECT_ORG_ID

Line 2634: pji_ac_aggr_pjp1_t fact1

2630: , SUM(fact1.CUSTOM14)
2631: , SUM(fact1.CUSTOM15)
2632: , g_default_prg_level prg_level
2633: FROM
2634: pji_ac_aggr_pjp1_t fact1
2635: , pji_time_CAL_PERIOD period
2636: , pji_time_CAL_QTR qtr
2637: WHERE
2638: fact1.calendar_type = 'G'

Line 2674: INSERT INTO pji_ac_aggr_pjp1_t

2670: BEGIN
2671:
2672: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2673:
2674: INSERT INTO pji_ac_aggr_pjp1_t
2675: (
2676: worker_id
2677: , PROJECT_ID
2678: , PROJECT_ORG_ID

Line 2816: pji_ac_aggr_pjp1_t fact1

2812: , SUM(fact1.CUSTOM14)
2813: , SUM(fact1.CUSTOM15)
2814: , g_default_prg_level prg_level
2815: FROM
2816: pji_ac_aggr_pjp1_t fact1
2817: , pji_time_ENT_PERIOD period
2818: , pji_time_ENT_QTR qtr
2819: WHERE
2820: fact1.calendar_type = 'E'

Line 2875: INSERT INTO PJI_AC_AGGR_PJP1_T

2871: l_line_type := 'GLR';
2872: END IF;
2873: END IF;
2874:
2875: INSERT INTO PJI_AC_AGGR_PJP1_T
2876: (
2877: worker_id
2878: , PROJECT_ID
2879: , PROJECT_ORG_ID

Line 3017: PJI_AC_AGGR_PJP1_T fact1

3013: , SUM(fact1.CUSTOM14)
3014: , SUM(fact1.CUSTOM15)
3015: , g_default_prg_level prg_level
3016: FROM
3017: PJI_AC_AGGR_PJP1_T fact1
3018: , pji_time_CAL_PERIOD period
3019: , pji_time_CAL_QTR qtr
3020: WHERE
3021: fact1.calendar_type = p_calendar_type