DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PJI_TIME_CAL_YEAR_V

Line 213: FROM pji_time_cal_year_V per

209: AND rpt.report_date = TO_DATE(p_time_id,'j')
210: AND rpt.record_type_id = 128
211: UNION ALL
212: SELECT start_date, end_date
213: FROM pji_time_cal_year_V per
214: ,pji_time_cal_rpt_struct rpt
215: WHERE 1=1
216: AND per.calendar_id = p_calendar_id
217: AND 'E' <> p_calendar_type