APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 39: from ben_elig_per_elctbl_chc

35: and a.pil_elctbl_popl_stat_cd = 'STRTD';
36: --
37: cursor c_all_auto(p_pil_elctbl_chc_popl_id number) is
38: select 'Y'
39: from ben_elig_per_elctbl_chc
40: where elctbl_flag = 'Y'
41: and auto_enrt_flag = 'N'
42: and pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;
43: --

Line 606: from ben_elig_per_elctbl_chc

602: --
603: cursor c_chk_epe_exists is
604: select ELIG_PER_ELCTBL_CHC_ID,
605: ELCTBL_FLAG
606: from ben_elig_per_elctbl_chc
607: where per_in_ler_id =p_per_in_ler_id
608: and business_group_id = p_business_group_id;
609: --
610: l_chk_epe_exists c_chk_epe_exists%rowtype;

Line 2489: -- ben_elig_per_elctbl_chc table. If the row is not there raising a error

2485: --
2486: -- Bug(2300866):Check cursor for Reopening Life Events
2487: -- Before reopening the life event need to have a check to see if
2488: -- the electable flag is 'Y' or whether a row there is a row in
2489: -- ben_elig_per_elctbl_chc table. If the row is not there raising a error
2490: -- Tilak : there can be first row is not eligible and secodn row is elctbl
2491: --- so it is neccessary to validate the elctbl flag 2
2492: cursor c_chk_reopen_lf_event is
2493: select ELIG_PER_ELCTBL_CHC_ID,

Line 2495: from ben_elig_per_elctbl_chc

2491: --- so it is neccessary to validate the elctbl flag 2
2492: cursor c_chk_reopen_lf_event is
2493: select ELIG_PER_ELCTBL_CHC_ID,
2494: ELCTBL_FLAG
2495: from ben_elig_per_elctbl_chc
2496: where per_in_ler_id =p_per_in_ler_id
2497: and elctbl_flag = 'Y'
2498: and business_group_id = p_business_group_id;
2499: --

Line 2507: from ben_elig_per_elctbl_chc epe,

2503: select enb.enrt_bnft_id,
2504: enb.object_version_number,
2505: enb.business_group_id,
2506: epe.prtt_enrt_rslt_id
2507: from ben_elig_per_elctbl_chc epe,
2508: ben_enrt_bnft enb
2509: where epe.per_in_ler_id = cv_per_in_ler_id
2510: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
2511: and epe.prtt_enrt_rslt_id IS NOT NULL