DBA Data[Home] [Help]

APPS.BEN_MANAGE_LIFE_EVENTS dependencies on BEN_ENRT_BNFT

Line 2824: (select enrt_bnft_id from ben_enrt_bnft

2820: union
2821: select *
2822: from ben_enrt_rt
2823: where enrt_bnft_id in
2824: (select enrt_bnft_id from ben_enrt_bnft
2825: where elig_per_elctbl_chc_id in
2826: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
2827: where per_in_ler_id = p_per_in_ler_id));
2828:

Line 10304: from ben_enrt_bnft

10300: acty_base_rt_id,
10301: null mark_delete
10302: from ben_enrt_rt
10303: where enrt_bnft_id in (select enrt_bnft_id
10304: from ben_enrt_bnft
10305: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
10306: );
10307:
10308: -- bug 12354919