APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on BEN_PLIP_F

Line 264: ben_plip_f plip,

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')
268: --and abr.cmbn_plip_id = l_cmbn_plip_id

Line 411: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_plip_f cpl, ben_plip_f cpp

407:
408: -- Process Combo PLIP Level Flex Credits
409: cursor c_bpp5 is
410: select bpp.bnft_prvdr_pool_id, bpp.cmbn_plip_id
411: from ben_bnft_prvdr_pool_f bpp,ben_cmbn_plip_f cpl, ben_plip_f cpp
412: where cpp.plip_id = l_plip_id
413: and cpp.cmbn_plip_id = cpl.cmbn_plip_id
414: and bpp.cmbn_plip_id = cpl.cmbn_plip_id
415: and nvl(p_lf_evt_ocrd_dt,p_effective_date)