APPS.PJI_FM_PLAN_CAL_RLPS dependencies on PJI_TIME_CAL_QTR

Line 445: , pji_time_CAL_QTR qtr

441: , fact1.plan_type_code plan_type_code /* 4471527 */
442: FROM
443: pji_fp_aggr_pjp1 fact1
444: , pji_time_CAL_PERIOD period
445: , pji_time_CAL_QTR qtr
446: WHERE
447: fact1.calendar_type = 'P'
448: AND period.cal_period_id = fact1.time_id
449: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 665: , pji_time_CAL_QTR qtr

661: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
662: FROM
663: pji_fp_aggr_pjp1 fact1
664: , pji_time_CAL_PERIOD period
665: , pji_time_CAL_QTR qtr
666: WHERE
667: fact1.calendar_type = l_calendar_type
668: AND period.cal_period_id = fact1.time_id
669: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 971: , pji_time_CAL_QTR qtr

967: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE /* 4471527 */
968: FROM
969: PJI_FP_AGGR_PJP1 fact1
970: , pji_time_CAL_PERIOD period
971: , pji_time_CAL_QTR qtr
972: , pji_fm_extr_plnver4 ver
973: WHERE
974: -- cal type changes for bug 6381284
975: --fact1.calendar_type = p_calendar_type

Line 1232: , pji_time_CAL_QTR qtr

1228: , SUM(fact1.CUSTOM15)
1229: FROM
1230: PJI_AC_AGGR_PJP1 fact1
1231: , pji_time_CAL_PERIOD period
1232: , pji_time_CAL_QTR qtr
1233: WHERE
1234: fact1.calendar_type = 'P'
1235: AND period.cal_period_id = fact1.time_id
1236: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1415: , pji_time_CAL_QTR qtr

1411: , SUM(fact1.CUSTOM15)
1412: FROM
1413: PJI_AC_AGGR_PJP1 fact1
1414: , pji_time_CAL_PERIOD period
1415: , pji_time_CAL_QTR qtr
1416: WHERE
1417: fact1.calendar_type = 'G'
1418: AND period.cal_period_id = fact1.time_id
1419: AND period.cal_qtr_id = qtr.cal_qtr_id

Line 1803: , pji_time_CAL_QTR qtr

1799: , SUM(fact1.CUSTOM15)
1800: FROM
1801: PJI_AC_AGGR_PJP1 fact1
1802: , pji_time_CAL_PERIOD period
1803: , pji_time_CAL_QTR qtr
1804: WHERE
1805: fact1.calendar_type = p_calendar_type
1806: AND period.cal_period_id = fact1.time_id
1807: AND period.cal_qtr_id = qtr.cal_qtr_id