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' -------Bug 8531750
41: or crntly_enrd_flag = 'Y') -------Bug 8531750
42: and auto_enrt_flag = 'N'
43: and pil_elctbl_chc_popl_id = p_pil_elctbl_chc_popl_id;

Line 607: from ben_elig_per_elctbl_chc

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

Line 660: FROM ben_elig_per_elctbl_chc epe1

656: --
657: -----Bug 8531750
658: cursor c_check_elctbl_chc(p_popl_id number) is
659: SELECT elctbl_flag
660: FROM ben_elig_per_elctbl_chc epe1
661: WHERE epe1.business_group_id = p_business_group_id
662: AND epe1.pil_elctbl_chc_popl_id = p_popl_id
663: AND epe1.elctbl_flag = 'Y';
664:

Line 669: FROM ben_elig_per_elctbl_chc epe

665: l_check_elctbl_chc c_check_elctbl_chc%rowtype;
666:
667: cursor c_check_cur_enr(p_popl_id number) is
668: SELECT elctbl_flag
669: FROM ben_elig_per_elctbl_chc epe
670: WHERE epe.business_group_id = p_business_group_id
671: AND epe.pil_elctbl_chc_popl_id = p_popl_id
672: AND epe.crntly_enrd_flag = 'Y'
673: AND epe.auto_enrt_flag = 'N';

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

2525: --
2526: -- Bug(2300866):Check cursor for Reopening Life Events
2527: -- Before reopening the life event need to have a check to see if
2528: -- the electable flag is 'Y' or whether a row there is a row in
2529: -- ben_elig_per_elctbl_chc table. If the row is not there raising a error
2530: -- Tilak : there can be first row is not eligible and secodn row is elctbl
2531: --- so it is neccessary to validate the elctbl flag 2
2532: cursor c_chk_reopen_lf_event is
2533: select ELIG_PER_ELCTBL_CHC_ID,

Line 2535: from ben_elig_per_elctbl_chc

2531: --- so it is neccessary to validate the elctbl flag 2
2532: cursor c_chk_reopen_lf_event is
2533: select ELIG_PER_ELCTBL_CHC_ID,
2534: ELCTBL_FLAG
2535: from ben_elig_per_elctbl_chc
2536: where per_in_ler_id =p_per_in_ler_id
2537: and elctbl_flag = 'Y'
2538: and business_group_id = p_business_group_id;
2539: --

Line 2547: from ben_elig_per_elctbl_chc epe,

2543: select enb.enrt_bnft_id,
2544: enb.object_version_number,
2545: enb.business_group_id,
2546: epe.prtt_enrt_rslt_id
2547: from ben_elig_per_elctbl_chc epe,
2548: ben_enrt_bnft enb
2549: where epe.per_in_ler_id = cv_per_in_ler_id
2550: and epe.elig_per_elctbl_chc_id = enb.elig_per_elctbl_chc_id
2551: and epe.prtt_enrt_rslt_id IS NOT NULL