eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGIRRPS dependencies on IGI_RPI_COMPONENT_PERIODS

Line 194: FROM igi_rpi_component_periods jr

190: CURSOR C_periods ( pp_period_name in varchar2) IS
191: SELECT nvl(js.schedule_id,0) schedule_id
192: , jr.component
193: , jr.factor
194: FROM igi_rpi_component_periods jr
195: , igi_rpi_period_schedules js
196: WHERE jr.period_name = pp_period_name
197: AND jr.schedule_id = js.schedule_id
198: AND js.period_name = pp_period_name

Line 201: FROM igi_rpi_component_periods jr

197: AND jr.schedule_id = js.schedule_id
198: AND js.period_name = pp_period_name
199: UNION
200: SELECT 0 schedule_id, jr.component, jr.factor
201: FROM igi_rpi_component_periods jr
202: WHERE jr.period_name = pp_period_name
203: AND NOT EXISTS ( select 'x'
204: from igi_rpi_period_schedules js
205: where js.period_name = jr.period_name

Line 246: FROM igi_rpi_component_periods jr

242: CURSOR C_periods ( pp_period_name in varchar2) IS
243: SELECT nvl(js.schedule_id,-1) schedule_id
244: , jr.component
245: , jr.factor
246: FROM igi_rpi_component_periods jr
247: , igi_rpi_period_schedules js
248: WHERE jr.period_name = pp_period_name
249: AND jr.schedule_id = js.schedule_id
250: AND js.period_name = pp_period_name

Line 253: FROM igi_rpi_component_periods jr

249: AND jr.schedule_id = js.schedule_id
250: AND js.period_name = pp_period_name
251: UNION
252: SELECT 0 schedule_id, jr.component, jr.factor
253: FROM igi_rpi_component_periods jr
254: WHERE jr.period_name = pp_period_name
255: AND NOT EXISTS ( select 'x'
256: from igi_rpi_period_schedules js
257: where js.period_name = jr.period_name