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 649: from ben_pil_elctbl_chc_popl a

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

Line 1088: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

1084:
1085: end if;
1086: --End Bug 6144967
1087:
1088: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
1089: (p_validate => p_validate
1090: ,p_pil_elctbl_chc_popl_id => l_rec.pil_elctbl_chc_popl_id
1091: ,p_pil_elctbl_popl_stat_cd => 'PROCD'
1092: ,p_business_group_id => p_business_group_id

Line 1958: from ben_pil_elctbl_chc_popl pel,

1954: -- End Bug 4193968
1955: and (p_person_id is null or pil.person_id = p_person_id)
1956: and (p_lf_evt_ocrd_dt is null
1957: or exists (select null
1958: from ben_pil_elctbl_chc_popl pel,
1959: ben_enrt_perd enp
1960: where pel.per_in_ler_id = pil.per_in_ler_id
1961: and pel.enrt_perd_id = enp.enrt_perd_id
1962: and enp.asnd_lf_evt_dt = l_lf_evt_ocrd_dt

Line 1967: from ben_pil_elctbl_chc_popl pel

1963: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
1964: /* PB : 5422 :
1965: and (p_popl_enrt_typ_cycl_id is null
1966: or exists (select null
1967: from ben_pil_elctbl_chc_popl pel
1968: where pel.per_in_ler_id = pil.per_in_ler_id
1969: and pel.enrt_perd_id = p_popl_enrt_typ_cycl_id
1970: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
1971: */

Line 1983: from ben_pil_elctbl_chc_popl pel

1979: and l_effective_date between
1980: paf.effective_start_date and paf.effective_end_date))
1981: and (p_pgm_id is null
1982: or exists(select null
1983: from ben_pil_elctbl_chc_popl pel
1984: where pel.pgm_id = p_pgm_id
1985: and pel.per_in_ler_id = pil.per_in_ler_id
1986: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
1987: and (p_pl_nip_id is null

Line 1989: from ben_pil_elctbl_chc_popl pel

1985: and pel.per_in_ler_id = pil.per_in_ler_id
1986: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ))
1987: and (p_pl_nip_id is null
1988: or exists(select null
1989: from ben_pil_elctbl_chc_popl pel
1990: where pl_id = p_pl_nip_id
1991: and pel.per_in_ler_id = pil.per_in_ler_id
1992: and pel.pgm_id is null
1993: and pel.pil_elctbl_popl_stat_cd = 'STRTD' ));

Line 2458: from ben_pil_elctbl_chc_popl pel

2454: and pil.per_in_ler_stat_cd not in ('VOIDD', 'BCKDT');
2455: --
2456: cursor c_get_pil_elctbl_chc_popl is
2457: select pel.*
2458: from ben_pil_elctbl_chc_popl pel
2459: where pel.per_in_ler_id = p_per_in_ler_id
2460: and pel.business_group_id = p_business_group_id;
2461: --
2462: cursor c_get_cbr_per_in_ler is

Line 2568: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl

2564: --
2565: -- Step 2 : Open all the pil electable choice popl rows.
2566: --
2567: for l_pel_rec in c_get_pil_elctbl_chc_popl loop
2568: ben_pil_elctbl_chc_popl_api.update_pil_elctbl_chc_popl
2569: (p_validate => p_validate
2570: ,p_pil_elctbl_chc_popl_id => l_pel_rec.pil_elctbl_chc_popl_id
2571: ,p_pil_elctbl_popl_stat_cd => 'STRTD'
2572: ,p_business_group_id => p_business_group_id