APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_ACTY_BASE_RT_F

Line 170: from ben_acty_base_rt_f abr

166:
167: -- Get Flex Credits at PGM level
168: cursor c_abr1 is
169: select abr.acty_base_rt_id
170: from ben_acty_base_rt_f abr
171: where abr.acty_base_rt_stat_cd = 'A'
172: and abr.rt_usg_cd in ('FLXCR')
173: and abr.pgm_id = l_pgm_id
174: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 182: from ben_acty_base_rt_f abr

178:
179: -- Get Flex Credits at PLIP level
180: cursor c_abr2 is
181: select abr.acty_base_rt_id
182: from ben_acty_base_rt_f abr
183: where abr.acty_base_rt_stat_cd = 'A'
184: and abr.rt_usg_cd in ('FLXCR')
185: and abr.plip_id = l_plip_id
186: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 196: from ben_acty_base_rt_f abr

192:
193: -- Get Flex Credits at PTIP level
194: cursor c_abr3 is
195: select abr.acty_base_rt_id
196: from ben_acty_base_rt_f abr
197: where abr.acty_base_rt_stat_cd = 'A'
198: and abr.rt_usg_cd in ('FLXCR')
199: and abr.ptip_id = l_ptip_id
200: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 213: from ben_acty_base_rt_f abr

209: -- Get Flex Credits at COMBO PTIP level
210: /*
211: cursor c_abr4 is
212: select abr.acty_base_rt_id
213: from ben_acty_base_rt_f abr
214: where abr.acty_base_rt_stat_cd = 'A'
215: and abr.rt_usg_cd in ('FLXCR')
216: and abr.cmbn_ptip_id = l_cmbn_ptip_id
217: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 226: from ben_acty_base_rt_f abr,

222: */
223:
224: cursor c_abr4 is
225: select abr.acty_base_rt_id, abr.cmbn_ptip_id
226: from ben_acty_base_rt_f abr,
227: ben_cmbn_ptip_f cptip,
228: ben_ptip_f ptip
229: where abr.acty_base_rt_stat_cd = 'A'
230: and abr.rt_usg_cd in ('FLXCR')

Line 253: from ben_acty_base_rt_f abr

249: -- Get Flex Credits at COMBO PLIP level
250: /*
251: cursor c_abr5 is
252: select abr.acty_base_rt_id
253: from ben_acty_base_rt_f abr
254: where abr.acty_base_rt_stat_cd = 'A'
255: and abr.rt_usg_cd in ('FLXCR')
256: and abr.cmbn_plip_id = l_cmbn_plip_id
257: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 263: from ben_acty_base_rt_f abr,

259: and abr.effective_end_date;
260: */
261: cursor c_abr5 is
262: select abr.acty_base_rt_id, abr.cmbn_plip_id
263: from ben_acty_base_rt_f abr,
264: ben_plip_f plip,
265: ben_cmbn_plip_f cplip
266: where abr.acty_base_rt_stat_cd = 'A'
267: and abr.rt_usg_cd in ('FLXCR')

Line 288: from ben_acty_base_rt_f abr

284: /*
285: -- Get Flex Credits at COMBO PTIP OPT level
286: cursor c_abr6 is
287: select abr.acty_base_rt_id
288: from ben_acty_base_rt_f abr
289: where abr.acty_base_rt_stat_cd = 'A'
290: and abr.rt_usg_cd in ('FLXCR')
291: and abr.cmbn_ptip_opt_id = l_cmbn_ptip_opt_id
292: and nvl(p_lf_evt_ocrd_dt,p_effective_date)

Line 305: from ben_acty_base_rt_f abr,

301: -- the flex credits defined at different levels.
302: --
303: cursor c_abr6 is
304: select abr.acty_base_rt_id, abr.cmbn_ptip_opt_id
305: from ben_acty_base_rt_f abr,
306: ben_optip_f otp,
307: ben_oipl_f oipl
308: where abr.acty_base_rt_stat_cd = 'A'
309: and abr.rt_usg_cd in ('FLXCR')

Line 326: from ben_acty_base_rt_f abr

322:
323: -- Get Flex Credits at OIPLIP level
324: cursor c_abr7 is
325: select abr.acty_base_rt_id
326: from ben_acty_base_rt_f abr
327: where abr.acty_base_rt_stat_cd = 'A'
328: and abr.rt_usg_cd in ('FLXCR')
329: and abr.oiplip_id = l_oiplip_id
330: and nvl(p_lf_evt_ocrd_dt,p_effective_date)