APPS.BEN_DETERMINE_RATES dependencies on BEN_ACTY_BASE_RT_CTFN_F

Line 443: BEN_ACTY_BASE_RT_CTFN_F abc

439: abc.enrt_ctfn_typ_cd,
440: abc.rqd_flag
441: from ben_enrt_rt ecr,
442: ben_enrt_bnft enb,
443: BEN_ACTY_BASE_RT_CTFN_F abc
444: where ecr.acty_base_rt_id = p_acty_base_rt_id
445: and ecr.business_group_id = p_business_group_id
446: and decode(ecr.enrt_bnft_id, null, ecr.elig_per_elctbl_chc_id,
447: enb.elig_per_elctbl_chc_id) =

Line 458: BEN_ACTY_BASE_RT_CTFN_F abc

454: select ecr.enrt_rt_id,
455: abc.enrt_ctfn_typ_cd,
456: abc.rqd_flag
457: from ben_enrt_rt ecr,
458: BEN_ACTY_BASE_RT_CTFN_F abc
459: where ecr.acty_base_rt_id = p_acty_base_rt_id
460: and ecr.business_group_id = p_business_group_id
461: and ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
462: and abc.acty_base_rt_id = ecr.acty_base_rt_id+0;

Line 472: BEN_ACTY_BASE_RT_CTFN_F abc

468: abc.enrt_ctfn_typ_cd,
469: abc.rqd_flag
470: from ben_enrt_rt ecr,
471: ben_enrt_bnft enb,
472: BEN_ACTY_BASE_RT_CTFN_F abc
473: where ecr.acty_base_rt_id = p_acty_base_rt_id
474: and ecr.business_group_id = p_business_group_id
475: and enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
476: and enb.enrt_bnft_id = ecr.enrt_bnft_id