APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on BEN_ENRT_BNFT

Line 9975: from ben_enrt_bnft enb

9971: --
9972: cursor c_enrt_bnft (p_elctbl_chc_id number) is
9973: select enb.enrt_bnft_id,
9974: enb.object_version_number
9975: from ben_enrt_bnft enb
9976: where enb.elig_per_elctbl_chc_id = p_elctbl_chc_id
9977: and enb.dflt_flag = 'N'
9978: and (exists (select null from
9979: ben_enrt_bnft enb2

Line 9979: ben_enrt_bnft enb2

9975: from ben_enrt_bnft enb
9976: where enb.elig_per_elctbl_chc_id = p_elctbl_chc_id
9977: and enb.dflt_flag = 'N'
9978: and (exists (select null from
9979: ben_enrt_bnft enb2
9980: where enb2.enrt_bnft_id = enb.enrt_bnft_id
9981: and enb2.dflt_val = enb2.val)
9982: or enb.cvg_mlt_cd not in ('FLRNG', 'CLRNG','FLPCLRNG','CLPFLRNG'));
9983: l_enrt_bnft c_enrt_bnft%rowtype;

Line 10744: ben_enrt_bnft_api.update_enrt_bnft

10740: fetch c_enrt_bnft into l_enrt_bnft;
10741: close c_enrt_bnft;
10742: if l_enrt_bnft.enrt_bnft_id is not null then
10743: --
10744: ben_enrt_bnft_api.update_enrt_bnft
10745: (p_enrt_bnft_id => l_enrt_bnft.enrt_bnft_id
10746: ,p_dflt_flag => 'Y'
10747: ,p_object_version_number => l_enrt_bnft.object_version_number
10748: ,p_effective_date => p_effective_date);