APPS.BEN_CLOSE_ENROLLMENT dependencies on BEN_PIL_ELCTBL_CHC_POPL

Line 32: from ben_pil_elctbl_chc_popl a

28: ,a.procg_end_dt
29: ,'N' set_flag
30: ,a.object_version_number
31: ,a.defer_deenrol_flag
32: from ben_pil_elctbl_chc_popl a
33: where a.per_in_ler_id = c_per_in_ler_id
34: and a.business_group_id = c_business_group_id
35: and a.pil_elctbl_popl_stat_cd = 'STRTD';
36: --

Line 650: from ben_pil_elctbl_chc_popl a

646: is
647: select
648: max(a.enrt_perd_end_dt),
649: min(a.enrt_perd_strt_dt)
650: from ben_pil_elctbl_chc_popl a
651: where a.per_in_ler_id = c_per_in_ler_id
652: and a.business_group_id = c_business_group_id
653: and a.pil_elctbl_popl_stat_cd = 'STRTD';
654: ---

Line 1128: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

1124:
1125: end if;
1126: --End Bug 6144967
1127:
1128: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
1129: (p_validate => p_validate
1130: ,p_pil_elctbl_chc_popl_id => l_rec.pil_elctbl_chc_popl_id
1131: ,p_pil_elctbl_popl_stat_cd => 'PROCD'
1132: ,p_business_group_id => p_business_group_id

Line 1998: from ben_pil_elctbl_chc_popl pel,

1994: -- End Bug 4193968
1995: and (p_person_id is null or pil.person_id = p_person_id)
1996: and (p_lf_evt_ocrd_dt is null
1997: or exists (select null
1998: from ben_pil_elctbl_chc_popl pel,
1999: ben_enrt_perd enp
2000: where pel.per_in_ler_id = pil.per_in_ler_id
2001: and pel.enrt_perd_id = enp.enrt_perd_id
2002: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt

Line 2007: from ben_pil_elctbl_chc_popl pel

2003: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
2004: /* PB : 5422 :
2005: and (p_popl_enrt_typ_cycl_id is null
2006: or exists (select null
2007: from ben_pil_elctbl_chc_popl pel
2008: where pel.per_in_ler_id = pil.per_in_ler_id
2009: and pel.enrt_perd_id = p_popl_enrt_typ_cycl_id
2010: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
2011: */

Line 2023: from ben_pil_elctbl_chc_popl pel

2019: and l_effective_date between
2020: paf.effective_start_date and paf.effective_end_date))
2021: and (p_pgm_id is null
2022: or exists(select null
2023: from ben_pil_elctbl_chc_popl pel
2024: where pel.pgm_id = p_pgm_id
2025: and pel.per_in_ler_id = pil.per_in_ler_id
2026: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
2027: and (p_pl_nip_id is null

Line 2029: from ben_pil_elctbl_chc_popl pel

2025: and pel.per_in_ler_id = pil.per_in_ler_id
2026: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
2027: and (p_pl_nip_id is null
2028: or exists(select null
2029: from ben_pil_elctbl_chc_popl pel
2030: where pl_id = p_pl_nip_id
2031: and pel.per_in_ler_id = pil.per_in_ler_id
2032: and pel.pgm_id is null
2033: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ));

Line 2498: from ben_pil_elctbl_chc_popl pel

2494: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT');
2495: --
2496: cursor c_get_pil_elctbl_chc_popl is
2497: select pel.*
2498: from ben_pil_elctbl_chc_popl pel
2499: where pel.per_in_ler_id = p_per_in_ler_id
2500: and pel.business_group_id = p_business_group_id;
2501: --
2502: cursor c_get_cbr_per_in_ler is

Line 2616: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

2612: --
2613: for l_pel_rec in c_get_pil_elctbl_chc_popl loop
2614: /*Bug 8604243: Added 'if' condition.*/
2615: if ( ben_back_out_life_event.g_no_reopen_flag = 'N') then
2616: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
2617: (p_validate => p_validate
2618: ,p_pil_elctbl_chc_popl_id => l_pel_rec.pil_elctbl_chc_popl_id
2619: ,p_pil_elctbl_popl_stat_cd => 'STRTD'
2620: ,p_business_group_id => p_business_group_id