APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ENRT_BNFT

Line 773: from ben_enrt_bnft enb

769: cursor c_enb(p_enrt_bnft_id number)
770: is
771: select enb.val,
772: enb.dflt_val
773: from ben_enrt_bnft enb
774: where enb.enrt_bnft_id = p_enrt_bnft_id;
775: --
776: --Bug 2192102 added new cursor to find the cvg at the same level
777: cursor c_enb_fc is

Line 781: ben_enrt_bnft enb,

777: cursor c_enb_fc is
778: select
779: enb.enrt_bnft_id
780: from
781: ben_enrt_bnft enb,
782: ben_elig_per_elctbl_chc epe,
783: ben_elig_per_elctbl_chc epe_fc
784: where
785: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 4320: ben_enrt_bnft enb

4316: enb.elig_per_elctbl_chc_id,
4317: ecr.acty_base_rt_id,
4318: ecr.business_group_id
4319: from ben_enrt_rt ecr,
4320: ben_enrt_bnft enb
4321: where enb.enrt_bnft_id = p_enrt_bnft_id
4322: and ecr.enrt_bnft_id = enb.enrt_bnft_id
4323: and ecr.acty_base_rt_id = p_acty_base_rt_id; --Bug 4143012 get the correct rate
4324: --