DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PJI_TIME_CAL_RPT_STRUCT

Line 148: ,pji_time_cal_rpt_struct rpt

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
152: AND per.cal_period_id = rpt.time_id

Line 184: ,pji_time_cal_rpt_struct rpt

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
188: AND per.cal_qtr_id = rpt.time_id

Line 214: ,pji_time_cal_rpt_struct rpt

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
218: AND per.cal_year_id = rpt.time_id

Line 283: , pji_time_cal_rpt_struct rpt

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
287: AND per.cal_period_id = rpt.time_id