APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_ACTY_BASE_RT_F

Line 119: from ben_acty_base_rt_f abr

115: and ecr.enrt_bnft_id = p_enrt_bnft_id ;
116: --
117: cursor c_acty_base_rt(c_acty_base_rt_id number) is
118: select abr.*
119: from ben_acty_base_rt_f abr
120: where abr.acty_base_rt_id = c_acty_base_rt_id
121: and p_effective_date between abr.effective_start_date and abr.effective_end_date ;
122: --
123: cursor c_flx_epe_ecr(c_per_in_ler_id number ) is

Line 684: from ben_acty_base_rt_f abr

680: cursor c_abr(cv_acty_base_rt_id number,
681: cv_effective_date date ) is
682: select input_value_id,
683: element_type_id
684: from ben_acty_base_rt_f abr
685: where abr.acty_base_rt_id = cv_acty_base_rt_id
686: and cv_effective_date between abr.effective_start_date
687: and abr.effective_end_date ;
688: --

Line 902: from ben_acty_base_rt_f abr

898: cursor c_abr(cv_acty_base_rt_id number,
899: cv_effective_date date ) is
900: select input_value_id,
901: element_type_id
902: from ben_acty_base_rt_f abr
903: where abr.acty_base_rt_id = cv_acty_base_rt_id
904: and cv_effective_date between abr.effective_start_date
905: and abr.effective_end_date ;
906: --

Line 1725: ben_acty_base_rt_f abr,

1721: prv.business_group_id,
1722: prv.acty_ref_perd_cd,
1723: prv.object_version_number
1724: from ben_prtt_rt_val prv,
1725: ben_acty_base_rt_f abr,
1726: ben_prtt_enrt_rslt_f pen
1727: where prv.prtt_rt_val_id <> p_prtt_rt_val_id
1728: and prv.prtt_rt_val_stat_cd IS NULL
1729: and prv.rt_strt_dt > p_rt_strt_dt