APPS.BEN_MANAGE_OVERRIDE dependencies on BEN_ENRT_RT

Line 109: from ben_enrt_rt ecr

105: l_enb c_enb%rowtype;
106: --
107: cursor c_enrt_rt(p_epe_id number, p_enrt_bnft_id number ) is
108: select ecr.*
109: from ben_enrt_rt ecr
110: where ecr.elig_per_elctbl_chc_id = p_epe_id
111: union
112: select ecr.*
113: from ben_enrt_rt ecr

Line 113: from ben_enrt_rt ecr

109: from ben_enrt_rt ecr
110: where ecr.elig_per_elctbl_chc_id = p_epe_id
111: union
112: select ecr.*
113: from ben_enrt_rt ecr
114: where ecr.elig_per_elctbl_chc_id is null
115: and ecr.enrt_bnft_id = p_enrt_bnft_id ;
116: --
117: cursor c_acty_base_rt(c_acty_base_rt_id number) is

Line 129: not in ( select ecr.elig_per_elctbl_chc_id from ben_enrt_rt ecr

125: from ben_elig_per_elctbl_chc epe
126: where epe.per_in_ler_id = c_per_in_ler_id
127: and epe.bnft_prvdr_pool_id is not null
128: and epe.elig_per_elctbl_chc_id
129: not in ( select ecr.elig_per_elctbl_chc_id from ben_enrt_rt ecr
130: where ecr.elig_per_elctbl_chc_id = epe.elig_per_elctbl_chc_id
131: and ecr.rt_usg_cd = 'FLXCR'
132: ) ;
133: --

Line 475: -- To create the ben_enrt_rt records for the flex credits setup

471: p_enrt_perd_strt_dt => l_date_dummy, -- This is not used in benflxii.pkb
472: p_effective_date => p_effective_date,
473: p_called_from => 'O' );
474: --
475: -- To create the ben_enrt_rt records for the flex credits setup
476: --
477: for l_flx_epe in c_flx_epe_ecr( p_per_in_ler_id ) loop
478: --
479: ben_epe_cache.clear_down_cache ;