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 574: , pji_time_CAL_QTR qtr

570: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
571: FROM
572: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
573: , pji_time_CAL_PERIOD period
574: , pji_time_CAL_QTR qtr
575: , pji_fm_extr_plnver3_t ver
576: WHERE
577: fact1.calendar_type = 'P'
578: AND period.cal_period_id = fact1.time_id

Line 819: , pji_time_CAL_QTR qtr

815: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
816: FROM
817: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
818: , pji_time_CAL_PERIOD period
819: , pji_time_CAL_QTR qtr
820: , pji_fm_extr_plnver3_t ver
821: WHERE
822: fact1.calendar_type = l_calendar_type
823: AND period.cal_period_id = fact1.time_id

Line 1094: , pji_time_CAL_QTR qtr

1090: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1091: FROM
1092: PJI_FP_AGGR_PJP1_T fact1
1093: , pji_time_CAL_PERIOD period
1094: , pji_time_CAL_QTR qtr
1095: , pji_fm_extr_plnver3_t ver
1096: WHERE
1097: fact1.calendar_type IN ( l_calendar_type
1098: , DECODE (l_calendar_type ,'C','G','X')

Line 1216: , pji_time_CAL_QTR qtr

1212: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
1213: FROM
1214: PJI_FP_AGGR_PJP1_T fact1
1215: , pji_time_CAL_PERIOD period
1216: , pji_time_CAL_QTR qtr
1217: , pji_fm_extr_plnver3_t ver
1218: WHERE
1219: fact1.calendar_type IN ( p_calendar_type
1220: , DECODE (p_calendar_type ,'C','G','X')

Line 1910: , pji_time_CAL_QTR qtr

1906: , fact1.plan_type_code plan_type_code /* 4471527 */
1907: FROM
1908: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
1909: , pji_time_CAL_PERIOD period
1910: , pji_time_CAL_QTR qtr
1911: , pji_fm_extr_plnver3_t ver
1912: WHERE
1913: fact1.calendar_type = 'P'
1914: AND period.cal_period_id = fact1.time_id

Line 2153: , pji_time_CAL_QTR qtr

2149: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
2150: FROM
2151: pji_fp_aggr_pjp1_t fact1 -- , PJI_FM_EXTR_PLNVER3_T ver
2152: , pji_time_CAL_PERIOD period
2153: , pji_time_CAL_QTR qtr
2154: , pji_fm_extr_plnver3_t ver
2155: WHERE
2156: fact1.calendar_type = 'G'
2157: AND period.cal_period_id = fact1.time_id

Line 2591: , pji_time_CAL_QTR qtr

2587: , g_default_prg_level prg_level
2588: FROM
2589: pji_ac_aggr_pjp1_t fact1
2590: , pji_time_CAL_PERIOD period
2591: , pji_time_CAL_QTR qtr
2592: WHERE
2593: fact1.calendar_type = 'P'
2594: AND period.cal_period_id = fact1.time_id
2595: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 2774: , pji_time_CAL_QTR qtr

2770: , g_default_prg_level prg_level
2771: FROM
2772: pji_ac_aggr_pjp1_t fact1
2773: , pji_time_CAL_PERIOD period
2774: , pji_time_CAL_QTR qtr
2775: WHERE
2776: fact1.calendar_type = 'G'
2777: AND period.cal_period_id = fact1.time_id
2778: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 3157: , pji_time_CAL_QTR qtr

3153: , g_default_prg_level prg_level
3154: FROM
3155: PJI_AC_AGGR_PJP1_T fact1
3156: , pji_time_CAL_PERIOD period
3157: , pji_time_CAL_QTR qtr
3158: WHERE
3159: fact1.calendar_type = p_calendar_type
3160: AND period.cal_period_id = fact1.time_id
3161: AND period.cal_qtr_id = qtr.cal_qtr_id