DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_TIME_ENT_PERIOD_V

Line 1350: , pji_time_ent_period_v pa_cal

1346: / (non_pa_cal.end_date - non_pa_cal.start_date+1) factor
1347: , fact.plan_type_code plan_type_code
1348: FROM pji_fp_aggr_pjp1 fact
1349: , pji_time_cal_period_v non_pa_cal
1350: , pji_time_ent_period_v pa_cal
1351: , pji_fm_extr_plnver4 ver
1352: , (SELECT currency_code,
1353: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1354: null, 0.01,

Line 1643: , pji_time_ent_period_v entCal

1639: , (LEAST(fact.end_date,entCal.end_date) - Greatest(fact.start_date,entCal.start_date)+1)
1640: / (fact.end_date - fact.start_date+1) factor
1641: , fact.plan_type_code plan_type_code
1642: FROM pji_fp_aggr_pjp1 fact
1643: , pji_time_ent_period_v entCal
1644: , pji_fm_extr_plnver4 ver
1645: , (SELECT currency_code,
1646: decode(nvl(MINIMUM_ACCOUNTABLE_UNIT, power(10, (-1 * PRECISION))),
1647: null, 0.01,