APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_ENT_PERIOD_V

Line 3220: , pji_time_ent_period_v pa_cal

3216: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
3217: , fact.plan_type_code plan_type_code /* 4471527 */
3218: FROM pji_fp_aggr_pjp1 fact
3219: , pji_time_cal_period_v non_pa_cal
3220: , pji_time_ent_period_v pa_cal
3221: , pji_fm_extr_plnver4 ver
3222: , (SELECT currency_code,
3223: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3224: null, 0.01,

Line 3529: , pji_time_ent_period_v entCal

3525: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
3526: / (fact.end_date - fact.start_date+1) factor
3527: , fact.plan_type_code plan_type_code /* 4471527 */
3528: FROM pji_fp_aggr_pjp1 fact
3529: , pji_time_ent_period_v entCal
3530: , pji_fm_extr_plnver4 ver
3531: , (SELECT currency_code,
3532: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
3533: null, 0.01,

Line 3949: , pji_time_ent_period_v pa_cal

3945: , g_default_prg_level prg_level
3946: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
3947: FROM pji_fp_aggr_pjp1 fact
3948: , pji_time_cal_period_v non_pa_cal
3949: , pji_time_ent_period_v pa_cal
3950: , pji_fm_extr_plnver4 ver
3951: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3952: AND fact.worker_id = g_worker_id
3953: AND ver.worker_id = g_worker_id

Line 4171: , pji_time_ent_period_v pa_cal

4167: , fact.RATE_DANGLING_FLAG RATE_DANGLING_FLAG
4168: , g_default_prg_level prg_level
4169: , fact.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
4170: FROM pji_fp_aggr_pjp1 fact
4171: , pji_time_ent_period_v pa_cal
4172: , pji_fm_extr_plnver4 ver
4173: WHERE fact.CALENDAR_TYPE = 'A'
4174: AND fact.worker_id = g_worker_id
4175: AND ver.worker_id = g_worker_id