eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_ENT_PERIOD

Line 220: , pji_time_ENT_PERIOD period

216: , 'ENTR'
217: , PLAN_TYPE_CODE /* 4471527 */
218: FROM
219: PJI_FP_AGGR_PJP1 fact1
220: , pji_time_ENT_PERIOD period
221: , pji_time_ENT_QTR qtr
222: WHERE
223: fact1.calendar_type = 'E'
224: AND period.ENT_period_id = fact1.time_id

Line 1596: , pji_time_ENT_PERIOD period

1592: , SUM(fact1.CUSTOM14)
1593: , SUM(fact1.CUSTOM15)
1594: FROM
1595: PJI_AC_AGGR_PJP1 fact1
1596: , pji_time_ENT_PERIOD period
1597: , pji_time_ENT_QTR qtr
1598: WHERE
1599: fact1.calendar_type = 'E'
1600: AND period.ENT_period_id = fact1.time_id

Line 2941: , pji_time_ent_period pa_cal

2937: , fact.time_dangling_flag time_dangling_flag
2938: , fact.rate_dangling_flag rate_dangling_flag
2939: FROM pji_fp_aggr_pjp1 fact
2940: , pji_time_cal_period non_pa_cal
2941: , pji_time_ent_period pa_cal
2942: , pji_fm_extr_plnver4 ver
2943: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
2944: AND fact.worker_id = g_worker_id
2945: AND non_pa_cal.cal_period_id = fact.time_id

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 3755: , pji_time_ent_period pa_cal

3751: , g_default_prg_level PRG_LEVEL
3752: FROM pji_fp_aggr_pjp1 fact
3753: , pji_time_cal_period non_pa_cal
3754: -- , pji_org_extr_info orginfo
3755: , pji_time_ent_period pa_cal
3756: , pji_fm_extr_plnver4 ver
3757: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3758: AND fact.worker_id = g_worker_id
3759: AND ver.worker_id = g_worker_id

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