APPS.PJI_FM_PLAN_CAL_RLPS_T dependencies on PJI_TIME_ENT_PERIOD_V

Line 4438: , pji_time_ent_period_v pa_cal

4434: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
4435: , fact.plan_type_code plan_type_code /* 4471527 */
4436: FROM pji_fp_aggr_pjp1_t fact
4437: , pji_time_cal_period_v non_pa_cal
4438: , pji_time_ent_period_v pa_cal
4439: , pji_fm_extr_plnver3_t ver
4440: , (SELECT currency_code,
4441: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
4442: null, 0.01,

Line 7029: , pji_time_ent_period_v entCal

7025: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
7026: / (fact.end_date - fact.start_date+1) factor
7027: , fact.plan_type_code plan_type_code /* 4471527 */
7028: FROM pji_fp_aggr_pjp1_t fact
7029: , pji_time_ent_period_v entCal
7030: , pji_fm_extr_plnver3_t ver
7031: , (SELECT currency_code,
7032: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
7033: null, 0.01,

Line 7446: , pji_time_ent_period_v pa_cal

7442: , g_default_prg_level prg_level
7443: , fact.plan_type_code plan_type_code /* 4471527 */
7444: FROM pji_fp_aggr_pjp1_t fact
7445: , pji_time_cal_period_v non_pa_cal
7446: , pji_time_ent_period_v pa_cal
7447: , pji_fm_extr_plnver3_t ver
7448: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
7449: AND fact.worker_id = g_worker_id
7450: AND non_pa_cal.cal_period_id = fact.time_id

Line 8067: , pji_time_ent_period_v pa_cal

8063: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
8064: , g_default_prg_level prg_level
8065: , fact.plan_type_code plan_type_code /* 4471527 */
8066: FROM pji_fp_aggr_pjp1_t fact
8067: , pji_time_ent_period_v pa_cal
8068: , pji_fm_extr_plnver3_t ver
8069: WHERE fact.CALENDAR_TYPE = 'A'
8070: AND fact.worker_id = g_worker_id
8071: AND fact.line_type = 'NTP'