[Home] [Help]
37: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
38: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
39: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
40: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
41: ler_id ben_ler_f.ler_id%type,
42: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
43: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
44: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
45: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type
494: ler.name,
495: pil.bckt_per_in_ler_id,
496: ler_cs_bckdt.name ler_cs_bckdt_name
497: from ben_per_in_ler pil
498: ,ben_ler_f ler
499: ,ben_per_in_ler pil_cs_bckdt
500: ,ben_ler_f ler_cs_bckdt
501: ,ben_ptnl_ler_for_per plr
502: where pil.person_id = p_person_id
496: ler_cs_bckdt.name ler_cs_bckdt_name
497: from ben_per_in_ler pil
498: ,ben_ler_f ler
499: ,ben_per_in_ler pil_cs_bckdt
500: ,ben_ler_f ler_cs_bckdt
501: ,ben_ptnl_ler_for_per plr
502: where pil.person_id = p_person_id
503: and pil.business_group_id = p_business_group_id
504: and pil.ler_id = p_ler_id
768: --
769: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
770: select pil.per_in_ler_id, pil.object_version_number
771: from ben_per_in_ler pil,
772: ben_ler_f ler
773: where pil.per_in_ler_id <> p_per_in_ler_id
774: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
775: and pil.person_id = p_person_id
776: and pil.ler_id = ler.ler_id
843: --
844: cursor c_ele_md_for_inter_pil is
845: select 'Y'
846: from ben_prtt_enrt_rslt_f pen,
847: ben_ler_f ler
848: where pen.per_in_ler_id <> p_bckdt_per_in_ler_id
849: and pen.person_id = p_person_id
850: and pen.prtt_enrt_rslt_stat_cd is null
851: -- and pen.enrt_cvg_thru_dt = hr_api.g_eot BUG 4642657
863: --
864: cursor c_prev_pil(p_bckt_csd_lf_evt_ocrd_dt date,p_bckt_csd_per_in_ler_id number ) is
865: select pil.per_in_ler_id
866: from ben_per_in_ler pil,
867: ben_ler_f ler
868: where pil.per_in_ler_id not in (p_per_in_ler_id,p_bckt_csd_per_in_ler_id)
869: and pil.person_id = p_person_id
870: and pil.ler_id = ler.ler_id
871: and p_effective_date between
3546: --
3547: cursor c_inter_pil_cnt(cv_bckt_csd_lf_evt_ocrd_dt date) is
3548: select pil.per_in_ler_id, pil.object_version_number
3549: from ben_per_in_ler pil,
3550: ben_ler_f ler
3551: where pil.per_in_ler_id <> p_per_in_ler_id
3552: and pil.per_in_ler_id <> p_bckdt_per_in_ler_id
3553: and pil.person_id = p_person_id
3554: and pil.ler_id = ler.ler_id
5979: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
5980: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
5981: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
5982: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
5983: ler_id ben_ler_f.ler_id%type,
5984: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
5985: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
5986: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
5987: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type
9138: --
9139: cursor c_bckdt_pil is
9140: select ler.name, pil.PRVS_STAT_CD, pil.object_version_number, pil.BCKT_PER_IN_LER_ID
9141: from ben_per_in_ler pil,
9142: ben_ler_f ler
9143: where pil.per_in_ler_id = p_bckdt_per_in_ler_id
9144: and ler.ler_id = pil.ler_id
9145: and p_effective_date between ler.effective_start_date
9146: and ler.effective_end_date ;
10205: new_oipl_id ben_prtt_enrt_rslt_f.oipl_id%type,
10206: old_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
10207: new_pl_typ_id ben_prtt_enrt_rslt_f.pl_typ_id%type,
10208: pgm_id ben_prtt_enrt_rslt_f.pgm_id%type,
10209: ler_id ben_ler_f.ler_id%type,
10210: elig_per_elctbl_chc_id ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type,
10211: dpnt_cvg_strt_dt_cd ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_cd%type,
10212: dpnt_cvg_strt_dt_rl ben_elig_per_elctbl_chc.dpnt_cvg_strt_dt_rl%type,
10213: effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%type