APPS.BEN_DETERMINE_RATES dependencies on BEN_ACTY_BASE_RT_CTFN_F

Line 441: BEN_ACTY_BASE_RT_CTFN_F abc

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

Line 456: BEN_ACTY_BASE_RT_CTFN_F abc

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

Line 470: BEN_ACTY_BASE_RT_CTFN_F abc

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