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 1542: ben_per_in_ler pil

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

Line 1567: from ben_per_in_ler pil,

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

Line 1634: from ben_per_in_ler pil

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

Line 2533: From ben_per_in_ler

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