APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on PJI_AC_AGGR_PJP1_T

Line 2447: INSERT INTO pji_ac_aggr_pjp1_t

2443: BEGIN
2444:
2445: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2446:
2447: INSERT INTO pji_ac_aggr_pjp1_t
2448: (
2449: WORKER_ID
2450: , PROJECT_ID
2451: , PROJECT_ORG_ID

Line 2589: pji_ac_aggr_pjp1_t fact1

2585: , SUM(fact1.CUSTOM14)
2586: , SUM(fact1.CUSTOM15)
2587: , g_default_prg_level prg_level
2588: FROM
2589: pji_ac_aggr_pjp1_t fact1
2590: , pji_time_CAL_PERIOD period
2591: , pji_time_CAL_QTR qtr
2592: WHERE
2593: fact1.calendar_type = 'P'

Line 2630: INSERT INTO pji_ac_aggr_pjp1_t

2626: BEGIN
2627:
2628: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2629:
2630: INSERT INTO pji_ac_aggr_pjp1_t
2631: (
2632: worker_id
2633: , PROJECT_ID
2634: , PROJECT_ORG_ID

Line 2772: pji_ac_aggr_pjp1_t fact1

2768: , SUM(fact1.CUSTOM14)
2769: , SUM(fact1.CUSTOM15)
2770: , g_default_prg_level prg_level
2771: FROM
2772: pji_ac_aggr_pjp1_t fact1
2773: , pji_time_CAL_PERIOD period
2774: , pji_time_CAL_QTR qtr
2775: WHERE
2776: fact1.calendar_type = 'G'

Line 2812: INSERT INTO pji_ac_aggr_pjp1_t

2808: BEGIN
2809:
2810: -- g_worker_id := PJI_PJP_FP_CURR_WRAP.GET_WORKER_ID;
2811:
2812: INSERT INTO pji_ac_aggr_pjp1_t
2813: (
2814: worker_id
2815: , PROJECT_ID
2816: , PROJECT_ORG_ID

Line 2954: pji_ac_aggr_pjp1_t fact1

2950: , SUM(fact1.CUSTOM14)
2951: , SUM(fact1.CUSTOM15)
2952: , g_default_prg_level prg_level
2953: FROM
2954: pji_ac_aggr_pjp1_t fact1
2955: , pji_time_ENT_PERIOD period
2956: , pji_time_ENT_QTR qtr
2957: WHERE
2958: fact1.calendar_type = 'E'

Line 3013: INSERT INTO PJI_AC_AGGR_PJP1_T

3009: l_line_type := 'GLR';
3010: END IF;
3011: END IF;
3012:
3013: INSERT INTO PJI_AC_AGGR_PJP1_T
3014: (
3015: worker_id
3016: , PROJECT_ID
3017: , PROJECT_ORG_ID

Line 3155: PJI_AC_AGGR_PJP1_T fact1

3151: , SUM(fact1.CUSTOM14)
3152: , SUM(fact1.CUSTOM15)
3153: , g_default_prg_level prg_level
3154: FROM
3155: PJI_AC_AGGR_PJP1_T fact1
3156: , pji_time_CAL_PERIOD period
3157: , pji_time_CAL_QTR qtr
3158: WHERE
3159: fact1.calendar_type = p_calendar_type