APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PER_IN_LER

Line 568: ben_per_in_ler pil

564: epe.object_version_number,
565: epe.elctbl_flag,
566: epe.per_in_ler_id
567: from ben_elig_per_elctbl_chc epe,
568: ben_per_in_ler pil
569: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
570: and epe.per_in_ler_id = pil.per_in_ler_id;
571: --
572: l_epe c_epe%rowtype;

Line 1633: ben_per_in_ler pil

1629: epe.crntly_enrd_flag,
1630: epe.elctbl_flag,
1631: epe.object_version_number
1632: from ben_elig_per_elctbl_chc epe,
1633: ben_per_in_ler pil
1634: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1635: and epe.per_in_ler_id = pil.per_in_ler_id ;
1636: --
1637: --bug 1895846 to check for the pending work flow or suspended enrollment results

Line 1642: ben_per_in_ler pil

1638: --
1639: cursor c_epe_in_pndg is
1640: select null
1641: from ben_elig_per_elctbl_chc epe,
1642: ben_per_in_ler pil
1643: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1644: and epe.per_in_ler_id = pil.per_in_ler_id
1645: and nvl(epe.in_pndg_wkflow_flag,'N') <> 'N' ;
1646: --

Line 1872: ben_per_in_ler pil

1868: enb.*
1869: from ben_prtt_enrt_rslt_f pen,
1870: ben_enrt_bnft enb,
1871: ben_elig_per_elctbl_chc epe,
1872: ben_per_in_ler pil
1873: where pen.business_group_id = l_business_group_id
1874: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1875: between pen.enrt_cvg_strt_dt
1876: and pen.enrt_cvg_thru_dt

Line 1926: ben_per_in_ler pil,

1922: select 'Y'
1923: from
1924: ben_prtt_enrt_rslt_f pen,
1925: ben_prtt_enrt_actn_f pea,
1926: ben_per_in_ler pil,
1927: ben_prtt_enrt_ctfn_prvdd_f ecp
1928: where
1929: -- pen
1930: pen.person_id=p_person_id

Line 2022: FROM ben_per_in_ler pil,

2018: epe.pl_id,
2019: epe.oipl_id,
2020: epe.pgm_id,
2021: epe.pl_typ_id
2022: FROM ben_per_in_ler pil,
2023: ben_elig_per_elctbl_chc epe
2024: WHERE pil.business_group_id = epe.business_group_id
2025: AND pil.per_in_ler_id = epe.per_in_ler_id
2026: AND epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 2033: FROM ben_per_in_ler pil,

2029: l_get_pil_elctbl c_get_pil_elctbl%rowtype;
2030:
2031: cursor c_get_prev_pil(p_person_id number) is
2032: SELECT pil.*
2033: FROM ben_per_in_ler pil,
2034: ben_ler_f ler
2035: WHERE pil.person_id = p_person_id
2036: AND pil.ler_id = ler.ler_id
2037: AND ler.business_group_id = pil.business_group_id