DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTIVITY_BASE_RT dependencies on BEN_ENRT_BNFT

Line 756: from ben_enrt_bnft enb

752: cursor c_enb(p_enrt_bnft_id number)
753: is
754: select enb.val,
755: enb.dflt_val
756: from ben_enrt_bnft enb
757: where enb.enrt_bnft_id = p_enrt_bnft_id;
758: --
759: --Bug 2192102 added new cursor to find the cvg at the same level
760: cursor c_enb_fc is

Line 764: ben_enrt_bnft enb,

760: cursor c_enb_fc is
761: select
762: enb.enrt_bnft_id
763: from
764: ben_enrt_bnft enb,
765: ben_elig_per_elctbl_chc epe,
766: ben_elig_per_elctbl_chc epe_fc
767: where
768: enb.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id

Line 4121: ben_enrt_bnft enb

4117: enb.elig_per_elctbl_chc_id,
4118: ecr.acty_base_rt_id,
4119: ecr.business_group_id
4120: from ben_enrt_rt ecr,
4121: ben_enrt_bnft enb
4122: where enb.enrt_bnft_id = p_enrt_bnft_id
4123: and ecr.enrt_bnft_id = enb.enrt_bnft_id
4124: and ecr.acty_base_rt_id = p_acty_base_rt_id; --Bug 4143012 get the correct rate
4125: --