518: , fact1.plan_type_code plan_type_code
519: FROM
520: pji_fp_aggr_pjp1 fact1
521: , pji_time_CAL_PERIOD period
522: , pji_time_CAL_QTR qtr
523: WHERE
524: fact1.calendar_type = 'P'
525: AND period.cal_period_id = fact1.time_id
526: AND period.cal_qtr_id = qtr.cal_qtr_id
827: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
828: FROM
829: pji_fp_aggr_pjp1 fact1
830: , pji_time_CAL_PERIOD period
831: , pji_time_CAL_QTR qtr
832: WHERE
833: fact1.calendar_type = l_calendar_type
834: AND period.cal_period_id = fact1.time_id
835: AND period.cal_qtr_id = qtr.cal_qtr_id
1060: , fact1.PLAN_TYPE_CODE PLAN_TYPE_CODE
1061: FROM
1062: PJI_FP_AGGR_PJP1 fact1
1063: , pji_time_CAL_PERIOD period
1064: , pji_time_CAL_QTR qtr
1065: , pji_fm_extr_plnver4 ver
1066: WHERE
1067: fact1.calendar_type in ( p_calendar_type
1068: , DECODE (p_calendar_type ,'C','G','X')