DBA Data[Home] [Help]

APPS.PJI_PJP_PRG_PERF_ALL dependencies on PJI_TIME_CAL_QTR

Line 522: , pji_time_CAL_QTR qtr

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

Line 831: , pji_time_CAL_QTR qtr

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

Line 1064: , pji_time_CAL_QTR qtr

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')