APPS.BEN_CARRY_FORWARD_ITEMS dependencies on BEN_PER_IN_LER

Line 26: ,ben_per_in_ler pil

22:
23: cursor c_pen is
24: select pen.*
25: from ben_prtt_enrt_rslt_f pen
26: ,ben_per_in_ler pil
27: ,ben_ler_f ler
28: where pen.person_id = p_person_id
29: and pen.prtt_enrt_rslt_stat_cd is null
30: and pen.sspndd_flag = 'Y'

Line 51: ,ben_per_in_ler pil

47: cursor c_get_actn_items_sus(p_prtt_enrt_rslt_id number,
48: p_eff_dt date) is
49: select pea.*
50: from ben_prtt_enrt_actn_f pea
51: ,ben_per_in_ler pil
52: where pea.business_group_id = p_business_group_id
53: and pea.cmpltd_dt is null
54: and pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
55: and pil.per_in_ler_id = pea.per_in_ler_id

Line 67: ,ben_per_in_ler pil

63: select pea.*,
64: pen.object_version_number pen_ovn
65: from ben_prtt_enrt_actn_f pea
66: ,ben_prtt_enrt_rslt_f pen
67: ,ben_per_in_ler pil
68: ,ben_ler_f ler
69: where pea.business_group_id = p_business_group_id
70: and pea.cmpltd_dt is null
71: and pea.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 354: from ben_per_in_ler pil

350: oipl.effective_end_date ;
351: --
352: cursor c_prev_per_in_ler is
353: select max(pil.lf_evt_ocrd_dt)
354: from ben_per_in_ler pil
355: where pil.business_group_id = p_business_group_id
356: and pil.person_id = p_person_id
357: and pil.per_in_ler_id <> p_per_in_ler_id
358: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD');

Line 858: from ben_per_in_ler pil

854: p_effective_date in date) is
855: --
856: cursor c_pil is
857: select pil.lf_evt_ocrd_dt
858: from ben_per_in_ler pil
859: where pil.per_in_ler_id = p_per_in_ler_id ;
860: --
861: l_lf_evt_ocrd_dt date;
862: --

Line 965: ben_per_in_ler pil,

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'
968: and pil.person_id = p_person_id
969: and pil.per_in_ler_id = p_per_in_ler_id

Line 1004: ben_per_in_ler pil,

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
1008: --and epe.business_group_id = pil.business_group_id

Line 1729: ben_per_in_ler pil

1725: --
1726: cursor c_get_past_pil (p_per_in_ler_id number) is
1727: select max(pea.per_in_ler_id)
1728: from ben_prtt_enrt_actn_f pea,
1729: ben_per_in_ler pil
1730: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1731: and pea.per_in_ler_id <> p_per_in_ler_id
1732: and pea.business_group_id = p_business_group_id
1733: and pea.per_in_ler_id = pil.per_in_ler_id

Line 1883: ben_per_in_ler pil

1879: cursor c_pen_sus is
1880: select pen.prtt_enrt_rslt_id,
1881: pen.per_in_ler_id
1882: from ben_prtt_enrt_rslt_f pen,
1883: ben_per_in_ler pil
1884: where pen.sspndd_flag = 'Y'
1885: and pen.per_in_ler_id <> pil.per_in_ler_id
1886: and pil.per_in_ler_id = p_per_in_ler_id
1887: and pen.person_id = pil.person_id