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 1006: ben_per_in_ler pil,

1002: --
1003: cursor c_elctbl_epe is
1004: select null
1005: from ben_elig_per_elctbl_chc epe,
1006: ben_per_in_ler pil,
1007: ben_pil_elctbl_chc_popl pel
1008: where epe.elctbl_flag = 'Y'
1009: --and pil.business_group_id = p_business_group_id
1010: --and epe.business_group_id = pil.business_group_id

Line 1783: ben_per_in_ler pil

1779: --
1780: cursor c_get_past_pil (p_per_in_ler_id number) is
1781: select max(pea.per_in_ler_id)
1782: from ben_prtt_enrt_actn_f pea,
1783: ben_per_in_ler pil
1784: where pea.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1785: and pea.per_in_ler_id <> p_per_in_ler_id
1786: and pea.business_group_id = p_business_group_id
1787: and pea.per_in_ler_id = pil.per_in_ler_id

Line 1937: ben_per_in_ler pil

1933: cursor c_pen_sus is
1934: select pen.prtt_enrt_rslt_id,
1935: pen.per_in_ler_id
1936: from ben_prtt_enrt_rslt_f pen,
1937: ben_per_in_ler pil
1938: where pen.sspndd_flag = 'Y'
1939: and pen.per_in_ler_id <> pil.per_in_ler_id
1940: and pil.per_in_ler_id = p_per_in_ler_id
1941: and pen.person_id = pil.person_id