APPS.BEN_PEN_BUS dependencies on BEN_PER_IN_LER

Line 895: FROM ben_per_in_ler pil

891: --
892: CURSOR c_lf_evt_ocrd_dt
893: IS
894: SELECT lf_evt_ocrd_dt
895: FROM ben_per_in_ler pil
896: WHERE pil.per_in_ler_id = p_per_in_ler_id;
897: --
898: CURSOR c_crt_ordr
899: IS

Line 1005: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil

1001: --
1002: CURSOR c_elig_dpnt
1003: IS
1004: SELECT NULL
1005: FROM ben_elig_cvrd_dpnt_f pdp, ben_per_in_ler pil
1006: WHERE pdp.dpnt_person_id = l_dpnt_id
1007: AND pdp.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1008: AND p_effective_date BETWEEN pdp.effective_start_date
1009: AND pdp.effective_end_date

Line 1543: ben_per_in_ler pil

1539: --
1540: cursor l_c_prev_pl(p_pl_id number) is
1541: select nvl(sum(pen.bnft_amt),0)
1542: from ben_prtt_enrt_rslt_f pen,
1543: ben_per_in_ler pil
1544: where pen.person_id = p_person_id
1545: and pen.prtt_enrt_rslt_stat_cd is null
1546: and pen.pl_id = p_pl_id
1547: and pil.person_id = p_person_id

Line 1568: from ben_per_in_ler pil,

1564: -- to get the ler_id of the STRTD per_in_ler
1565: --
1566: cursor c_ler(cv_pl_id number) is
1567: select pil.ler_id
1568: from ben_per_in_ler pil,
1569: ben_prtt_enrt_rslt_f pen
1570: where pil.person_id = p_person_id
1571: and pil.per_in_ler_stat_cd = 'STRTD'
1572: and pil.per_in_ler_id = pen.per_in_ler_id

Line 1635: from ben_per_in_ler pil

1631: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)
1632: and pen.per_in_ler_id = epe.per_in_ler_id (+)
1633: and pen.comp_lvl_cd not in ('PLANFC','PLANIMP')
1634: and exists (select null
1635: from ben_per_in_ler pil
1636: where pil.per_in_ler_id = epe.per_in_ler_id
1637: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT'))
1638: and cpp.pgm_id = pen.pgm_id
1639: and cpp.pl_id = pen.pl_id

Line 2534: From ben_per_in_ler

2530: and pen.person_id = p_person_id
2531: and nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2532: and pen.prtt_enrt_rslt_stat_cd is null)
2533: and per_in_ler_id in (select per_in_ler_id
2534: From ben_per_in_ler
2535: Where person_id = p_person_id
2536: and per_in_ler_stat_cd = 'STRTD'
2537: and business_group_id = p_business_group_id
2538: )