DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PJI_TIME_CAL_PERIOD_V

Line 147: FROM pji_time_cal_period_V per

143: AND rpt.report_date = TO_DATE(p_time_id,'j')
144: AND rpt.record_type_id = 256
145: UNION ALL
146: SELECT start_date, end_date
147: FROM pji_time_cal_period_V per
148: ,pji_time_cal_rpt_struct rpt
149: WHERE 1=1
150: AND per.calendar_id = p_calendar_id
151: AND 'E' <> p_calendar_type

Line 282: pji_time_cal_period_V per

278: AND rpt.record_type_id = 256
279: UNION ALL
280: SELECT start_date, end_date
281: FROM
282: pji_time_cal_period_V per
283: , pji_time_cal_rpt_struct rpt
284: WHERE 1=1
285: AND per.calendar_id = p_calendar_id
286: AND 'E' <> p_calendar_type