DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PJI_TIME_CAL_QTR_V

Line 183: FROM pji_time_cal_qtr_V per

179: AND rpt.report_date = TO_DATE(p_time_id,'j')
180: AND rpt.record_type_id = 512
181: UNION ALL
182: SELECT start_date, end_date
183: FROM pji_time_cal_qtr_V per
184: ,pji_time_cal_rpt_struct rpt
185: WHERE 1=1
186: AND per.calendar_id = p_calendar_id
187: AND 'E' <> p_calendar_type