APPS.IGIRRPS dependencies on IGI_RPI_PERIOD_SCHEDULES

Line 76: FROM igi_rpi_period_schedules

72: FUNCTION GetNewSchedPrevDate ( pp_schedule_id in number, pp_date in date )
73: return DATE IS
74: CURSOR c_sched IS
75: SELECT date1, date2, date3, date4
76: FROM igi_rpi_period_schedules
77: WHERE schedule_id = pp_schedule_id
78: AND nvl(enabled_flag,'Y') = 'Y';
79: l_Date date;
80: BEGIN

Line 129: FROM igi_rpi_period_schedules

125: FUNCTION GetNewSchedNextDate ( pp_schedule_id in number, pp_date in date )
126: return DATE IS
127: CURSOR c_sched IS
128: SELECT date1, date2, date3, date4
129: FROM igi_rpi_period_schedules
130: WHERE schedule_id = pp_schedule_id
131: AND nvl(enabled_flag,'Y') = 'Y';
132: l_Date date;
133: BEGIN

Line 195: , igi_rpi_period_schedules js

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
199: UNION

Line 204: from igi_rpi_period_schedules js

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
206: and js.schedule_id = jr.schedule_id
207: )
208: ;

Line 247: , igi_rpi_period_schedules js

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
251: UNION

Line 256: from igi_rpi_period_schedules js

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
258: and js.schedule_id = jr.schedule_id )
259: ;
260: l_Date date;