APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on PJI_TIME_ENT_PERIOD_V

Line 4576: , pji_time_ent_period_v pa_cal

4572: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4573: , fact.plan_type_code plan_type_code /* 4471527 */
4574: FROM pji_fp_aggr_pjp1_t fact
4575: , pji_time_cal_period_v non_pa_cal
4576: , pji_time_ent_period_v pa_cal
4577: , pji_fm_extr_plnver3_t ver
4578: , (SELECT currency_code,
4579: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4580: null, 0.01,

Line 7167: , pji_time_ent_period_v entCal

7163: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7164: / (fact.end_date - fact.start_date+1) factor
7165: , fact.plan_type_code plan_type_code /* 4471527 */
7166: FROM pji_fp_aggr_pjp1_t fact
7167: , pji_time_ent_period_v entCal
7168: , pji_fm_extr_plnver3_t ver
7169: , (SELECT currency_code,
7170: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7171: null, 0.01,

Line 7584: , pji_time_ent_period_v pa_cal

7580: , g_default_prg_level prg_level
7581: , fact.plan_type_code plan_type_code /* 4471527 */
7582: FROM pji_fp_aggr_pjp1_t fact
7583: , pji_time_cal_period_v non_pa_cal
7584: , pji_time_ent_period_v pa_cal
7585: , pji_fm_extr_plnver3_t ver
7586: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7587: AND fact.worker_id = g_worker_id
7588: AND non_pa_cal.cal_period_id = fact.time_id

Line 8205: , pji_time_ent_period_v pa_cal

8201: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8202: , g_default_prg_level prg_level
8203: , fact.plan_type_code plan_type_code /* 4471527 */
8204: FROM pji_fp_aggr_pjp1_t fact
8205: , pji_time_ent_period_v pa_cal
8206: , pji_fm_extr_plnver3_t ver
8207: WHERE fact.CALENDAR_TYPE = 'A'
8208: AND fact.worker_id = g_worker_id
8209: AND fact.line_type = 'NTP'