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_T dependencies on PJI_TIME_CAL_QTR

Line 453: , pji_time_CAL_QTR qtr

449: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
450: FROM
451: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
452: , pji_time_CAL_PERIOD period
453: , pji_time_CAL_QTR qtr
454: , pji_fm_extr_plnver3_t ver
455: WHERE
456: fact1.calendar_type = 'P'
457: AND period.cal_period_id = fact1.time_id

Line 698: , pji_time_CAL_QTR qtr

694: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
695: FROM
696: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
697: , pji_time_CAL_PERIOD period
698: , pji_time_CAL_QTR qtr
699: , pji_fm_extr_plnver3_t ver
700: WHERE
701: fact1.calendar_type = l_calendar_type
702: AND period.cal_period_id = fact1.time_id

Line 956: , pji_time_CAL_QTR qtr

952: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
953: FROM
954: PJI_FP_AGGR_PJP1_T fact1
955: , pji_time_CAL_PERIOD period
956: , pji_time_CAL_QTR qtr
957: , pji_fm_extr_plnver3_t ver
958: WHERE
959: fact1.calendar_type IN ( p_calendar_type
960: , DECODE (p_calendar_type ,'C','G','X')

Line 1078: , pji_time_CAL_QTR qtr

1074: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1075: FROM
1076: PJI_FP_AGGR_PJP1_T fact1
1077: , pji_time_CAL_PERIOD period
1078: , pji_time_CAL_QTR qtr
1079: , pji_fm_extr_plnver3_t ver
1080: WHERE
1081: fact1.calendar_type IN ( p_calendar_type
1082: , DECODE (p_calendar_type ,'C','G','X')

Line 1772: , pji_time_CAL_QTR qtr

1768: , fact1.plan_type_code plan_type_code /* 4471527 */
1769: FROM
1770: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1771: , pji_time_CAL_PERIOD period
1772: , pji_time_CAL_QTR qtr
1773: , pji_fm_extr_plnver3_t ver
1774: WHERE
1775: fact1.calendar_type = 'P'
1776: AND period.cal_period_id = fact1.time_id

Line 2015: , pji_time_CAL_QTR qtr

2011: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2012: FROM
2013: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2014: , pji_time_CAL_PERIOD period
2015: , pji_time_CAL_QTR qtr
2016: , pji_fm_extr_plnver3_t ver
2017: WHERE
2018: fact1.calendar_type = 'G'
2019: AND period.cal_period_id = fact1.time_id

Line 2453: , pji_time_CAL_QTR qtr

2449: , g_default_prg_level prg_level
2450: FROM
2451: pji_ac_aggr_pjp1_t fact1
2452: , pji_time_CAL_PERIOD period
2453: , pji_time_CAL_QTR qtr
2454: WHERE
2455: fact1.calendar_type = 'P'
2456: AND period.cal_period_id = fact1.time_id
2457: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 2636: , pji_time_CAL_QTR qtr

2632: , g_default_prg_level prg_level
2633: FROM
2634: pji_ac_aggr_pjp1_t fact1
2635: , pji_time_CAL_PERIOD period
2636: , pji_time_CAL_QTR qtr
2637: WHERE
2638: fact1.calendar_type = 'G'
2639: AND period.cal_period_id = fact1.time_id
2640: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 3019: , pji_time_CAL_QTR qtr

3015: , g_default_prg_level prg_level
3016: FROM
3017: PJI_AC_AGGR_PJP1_T fact1
3018: , pji_time_CAL_PERIOD period
3019: , pji_time_CAL_QTR qtr
3020: WHERE
3021: fact1.calendar_type = p_calendar_type
3022: AND period.cal_period_id = fact1.time_id
3023: AND period.cal_qtr_id = qtr.cal_qtr_id