DBA Data[Home] [Help]

APPS.PJI_REP_DFLT_DRILLDOWN_TXN dependencies on PJI_TIME_RPT_STRUCT

Line 139: ,pji_time_rpt_struct rpt

135: FROM
136: (
137: SELECT start_date, end_date
138: FROM pji_time_ent_period_v per
139: ,pji_time_rpt_struct rpt
140: WHERE 1=1
141: AND 'E' = p_calendar_type
142: AND per.ent_period_id = rpt.time_id
143: AND rpt.report_date = TO_DATE(p_time_id,'j')

Line 175: ,pji_time_rpt_struct rpt

171: FROM
172: (
173: SELECT start_date, end_date
174: FROM pji_time_ent_QTR_v per
175: ,pji_time_rpt_struct rpt
176: WHERE 1=1
177: AND 'E' = p_calendar_type
178: AND per.ent_qtr_id = rpt.time_id
179: AND rpt.report_date = TO_DATE(p_time_id,'j')

Line 205: ,pji_time_rpt_struct rpt

201: FROM
202: (
203: SELECT start_date, end_date
204: FROM pji_time_ent_year_v per
205: ,pji_time_rpt_struct rpt
206: WHERE 1=1
207: AND 'E' = p_calendar_type
208: AND per.ent_year_id = rpt.time_id
209: AND rpt.report_date = TO_DATE(p_time_id,'j')

Line 273: , pji_time_rpt_struct rpt

269: (
270: SELECT start_date, end_date
271: FROM
272: pji_time_ent_period_v per
273: , pji_time_rpt_struct rpt
274: WHERE 1=1
275: AND 'E' = p_calendar_type
276: AND per.ent_period_id = rpt.time_id
277: AND rpt.report_date = TO_DATE(p_time_id,'j')