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 227: , pji_time_ENT_PERIOD period

223: , 'ENTR'
224: , PLAN_TYPE_CODE /* 4471527 */
225: FROM
226: PJI_FP_AGGR_PJP1 fact1
227: , pji_time_ENT_PERIOD period
228: , pji_time_ENT_QTR qtr
229: WHERE
230: fact1.calendar_type = 'E'
231: AND period.ENT_period_id = fact1.time_id

Line 1836: , pji_time_ENT_PERIOD period

1832: , SUM(fact1.CUSTOM14)
1833: , SUM(fact1.CUSTOM15)
1834: FROM
1835: PJI_AC_AGGR_PJP1 fact1
1836: , pji_time_ENT_PERIOD period
1837: , pji_time_ENT_QTR qtr
1838: WHERE
1839: fact1.calendar_type = 'E'
1840: AND period.ENT_period_id = fact1.time_id

Line 3188: , pji_time_ent_period pa_cal

3184: , fact.time_dangling_flag time_dangling_flag
3185: , fact.rate_dangling_flag rate_dangling_flag
3186: FROM pji_fp_aggr_pjp1 fact
3187: , pji_time_cal_period non_pa_cal
3188: , pji_time_ent_period pa_cal
3189: , pji_fm_extr_plnver4 ver
3190: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
3191: AND fact.worker_id = g_worker_id
3192: AND non_pa_cal.cal_period_id = fact.time_id

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

4009: , g_default_prg_level PRG_LEVEL
4010: FROM pji_fp_aggr_pjp1 fact
4011: , pji_time_cal_period non_pa_cal
4012: -- , pji_org_extr_info orginfo
4013: , pji_time_ent_period pa_cal
4014: , pji_fm_extr_plnver4 ver
4015: WHERE fact.CALENDAR_TYPE IN ('P', 'G')
4016: AND fact.worker_id = g_worker_id
4017: AND ver.worker_id = g_worker_id

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