APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ENRT_BNFT

Line 9833: from ben_enrt_bnft enb

9829: --
9830: cursor c_enrt_bnft (p_elctbl_chc_id number) is
9831: select enb.enrt_bnft_id,
9832: enb.object_version_number
9833: from ben_enrt_bnft enb
9834: where enb.elig_per_elctbl_chc_id = p_elctbl_chc_id
9835: and enb.dflt_flag = 'N'
9836: and (exists (select null from
9837: ben_enrt_bnft enb2

Line 9837: ben_enrt_bnft enb2

9833: from ben_enrt_bnft enb
9834: where enb.elig_per_elctbl_chc_id = p_elctbl_chc_id
9835: and enb.dflt_flag = 'N'
9836: and (exists (select null from
9837: ben_enrt_bnft enb2
9838: where enb2.enrt_bnft_id = enb.enrt_bnft_id
9839: and enb2.dflt_val = enb2.val)
9840: or enb.cvg_mlt_cd not in ('FLRNG', 'CLRNG','FLPCLRNG','CLPFLRNG'));
9841: l_enrt_bnft c_enrt_bnft%rowtype;

Line 10551: ben_enrt_bnft_api.update_enrt_bnft

10547: fetch c_enrt_bnft into l_enrt_bnft;
10548: close c_enrt_bnft;
10549: if l_enrt_bnft.enrt_bnft_id is not null then
10550: --
10551: ben_enrt_bnft_api.update_enrt_bnft
10552: (p_enrt_bnft_id => l_enrt_bnft.enrt_bnft_id
10553: ,p_dflt_flag => 'Y'
10554: ,p_object_version_number => l_enrt_bnft.object_version_number
10555: ,p_effective_date => p_effective_date);