APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 94: from ben_elig_per_elctbl_chc epe

90: l_opt_unsus c_get_opt_actn_items_unsus%rowtype;
91: --
92: cursor c_epe(p_per_in_ler_id number) is
93: select 'Y' epe_found_flag
94: from ben_elig_per_elctbl_chc epe
95: where per_in_ler_id = p_per_in_ler_id
96: and (epe.pgm_id is NULL or
97: epe.pgm_id = l_pen_rec.pgm_id )
98: and (epe.oipl_id is NULL or

Line 963: from ben_elig_per_elctbl_chc epe,

959: epe.business_group_id,
960: 'N' stage,
961: 'N' suspended,
962: epe.cryfwd_elig_dpnt_cd
963: from ben_elig_per_elctbl_chc epe,
964: ben_enrt_bnft enb,
965: ben_per_in_ler pil,
966: ben_pil_elctbl_chc_popl pel
967: where NVL(enb.crntly_enrld_flag(+),epe.crntly_enrd_flag) = 'Y'

Line 1005: from ben_elig_per_elctbl_chc epe,

1001: l_choice_info c_choice_info%rowtype;
1002: --
1003: cursor c_elctbl_epe is
1004: select null
1005: from ben_elig_per_elctbl_chc epe,
1006: ben_per_in_ler pil,
1007: ben_pil_elctbl_chc_popl pel
1008: where epe.elctbl_flag = 'Y'
1009: --and pil.business_group_id = p_business_group_id

Line 1034: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

1030: and pen.effective_end_date = hr_api.g_eot));
1031: --
1032: cursor c_pgm_enrt_dt(v_elig_per_elctbl_chc_id number,v_pgm_id number) is
1033: select pel.enrt_perd_strt_dt
1034: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
1035: where pel.pgm_id = v_pgm_id
1036: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1037: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1038:

Line 1043: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

1039: l_pgm_enrt_dt c_pgm_enrt_dt%rowtype;
1040:
1041: cursor c_pl_enrt_dt(v_elig_per_elctbl_chc_id number,v_pl_id number) is
1042: select pel.enrt_perd_strt_dt
1043: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe
1044: where pel.pl_id = v_pl_id
1045: and pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1046: and epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id;
1047:

Line 1359: update ben_elig_per_elctbl_chc

1355: --When carrying forward enrollment, remove defaults for all other
1356: -- plans/options in that plan type.
1357: --Need to be changed with API at a later date.
1358: --
1359: update ben_elig_per_elctbl_chc
1360: set dflt_flag = 'N'
1361: where pl_typ_id = l_choice_info.pl_typ_id
1362: and elig_per_elctbl_chc_id <> l_choice_info.elig_per_elctbl_chc_id
1363: and crntly_enrd_flag = 'N' -- Bug 7378468

Line 1497: update ben_elig_per_elctbl_chc

1493: -- update the default flag to N on the interim epe
1494: --
1495: /* Bug 5474065 : Updating the DFLT_FLAG prevents interim enrollment when interim
1496: code has Current - Default
1497: update ben_elig_per_elctbl_chc
1498: set dflt_flag = 'N'
1499: where dflt_flag = 'Y'
1500: and per_in_ler_id = l_choice_info.per_in_ler_id
1501: and pl_id = l_choice_info.pl_id