APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_ENT_PERIOD_V

Line 3467: , pji_time_ent_period_v pa_cal

3463: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
3464: , fact.plan_type_code plan_type_code /* 4471527 */
3465: FROM pji_fp_aggr_pjp1 fact
3466: , pji_time_cal_period_v non_pa_cal
3467: , pji_time_ent_period_v pa_cal
3468: , pji_fm_extr_plnver4 ver
3469: , (SELECT currency_code,
3470: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3471: null, 0.01,

Line 3785: , pji_time_ent_period_v entCal

3781: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
3782: / (fact.end_date - fact.start_date+1) factor
3783: , fact.plan_type_code plan_type_code /* 4471527 */
3784: FROM pji_fp_aggr_pjp1 fact
3785: , pji_time_ent_period_v entCal
3786: , pji_fm_extr_plnver4 ver
3787: , (SELECT currency_code,
3788: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3789: null, 0.01,

Line 4207: , pji_time_ent_period_v pa_cal

4203: , g_default_prg_level prg_level
4204: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4205: FROM pji_fp_aggr_pjp1 fact
4206: , pji_time_cal_period_v non_pa_cal
4207: , pji_time_ent_period_v pa_cal
4208: , pji_fm_extr_plnver4 ver
4209: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4210: AND fact.worker_id = g_worker_id
4211: AND ver.worker_id = g_worker_id

Line 4429: , pji_time_ent_period_v pa_cal

4425: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4426: , g_default_prg_level prg_level
4427: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4428: FROM pji_fp_aggr_pjp1 fact
4429: , pji_time_ent_period_v pa_cal
4430: , pji_fm_extr_plnver4 ver
4431: WHERE fact.CALENDAR_TYPE = 'A'
4432: AND fact.worker_id = g_worker_id
4433: AND ver.worker_id = g_worker_id