APPS.BEN_ACTY_VRBL_RATE_API dependencies on BEN_ACTY_BASE_RT_F

Line 59: from ben_acty_base_rt_f

55: --
56: -- Declare cursors and local variables
57: --
58: cursor c1 is select pgm_id,pl_id,ptip_id,plip_id,oipl_id,opt_id
59: from ben_acty_base_rt_f
60: where acty_base_rt_id = p_acty_base_rt_id;
61: l_c1 c1%ROWTYPE;
62: --
63: -- Start Option Level Rates

Line 615: from ben_acty_base_rt_f abr, ben_acty_vrbl_rt_f avr

611: ) is
612: --
613: -- Declare cursors and local variables
614: cursor c1 is select pgm_id,pl_id,ptip_id,plip_id,oipl_id,opt_id
615: from ben_acty_base_rt_f abr, ben_acty_vrbl_rt_f avr
616: where abr.acty_base_rt_id = avr.acty_base_rt_id and
617: avr.acty_vrbl_rt_id = p_acty_vrbl_rt_id;
618:
619: --

Line 629: from ben_acty_base_rt_f abr

625: select distinct oipl_id
626: from ben_oipl_f oipl
627: where oipl.opt_id = p_opt_id
628: and not exists ( select abr.oipl_id
629: from ben_acty_base_rt_f abr
630: where abr.oipl_id = oipl.oipl_id
631: and p_effective_date between abr.effective_start_date
632: and abr.effective_end_date ) ;
633: --