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 1003: from ben_elig_per_elctbl_chc epe,

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

Line 1032: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

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

Line 1041: from ben_pil_elctbl_chc_popl pel,ben_elig_per_elctbl_chc epe

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

Line 1354: update ben_elig_per_elctbl_chc

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

Line 1482: update ben_elig_per_elctbl_chc

1478: -- update the default flag to N on the interim epe
1479: --
1480: /* Bug 5474065 : Updating the DFLT_FLAG prevents interim enrollment when interim
1481: code has Current - Default
1482: update ben_elig_per_elctbl_chc
1483: set dflt_flag = 'N'
1484: where dflt_flag = 'Y'
1485: and per_in_ler_id = l_choice_info.per_in_ler_id
1486: and pl_id = l_choice_info.pl_id