APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PER_IN_LER

Line 544: ben_per_in_ler pil

540: epe.object_version_number,
541: epe.elctbl_flag,
542: epe.per_in_ler_id
543: from ben_elig_per_elctbl_chc epe,
544: ben_per_in_ler pil
545: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
546: and epe.per_in_ler_id = pil.per_in_ler_id;
547: --
548: l_epe c_epe%rowtype;

Line 1594: ben_per_in_ler pil

1590: epe.crntly_enrd_flag,
1591: epe.elctbl_flag,
1592: epe.object_version_number
1593: from ben_elig_per_elctbl_chc epe,
1594: ben_per_in_ler pil
1595: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1596: and epe.per_in_ler_id = pil.per_in_ler_id ;
1597: --
1598: --bug 1895846 to check for the pending work flow or suspended enrollment results

Line 1603: ben_per_in_ler pil

1599: --
1600: cursor c_epe_in_pndg is
1601: select null
1602: from ben_elig_per_elctbl_chc epe,
1603: ben_per_in_ler pil
1604: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1605: and epe.per_in_ler_id = pil.per_in_ler_id
1606: and nvl(epe.in_pndg_wkflow_flag,'N') <> 'N' ;
1607: --

Line 1833: ben_per_in_ler pil

1829: enb.*
1830: from ben_prtt_enrt_rslt_f pen,
1831: ben_enrt_bnft enb,
1832: ben_elig_per_elctbl_chc epe,
1833: ben_per_in_ler pil
1834: where pen.business_group_id = l_business_group_id
1835: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1836: between pen.enrt_cvg_strt_dt
1837: and pen.enrt_cvg_thru_dt

Line 1886: ben_per_in_ler pil,

1882: select 'Y'
1883: from
1884: ben_prtt_enrt_rslt_f pen,
1885: ben_prtt_enrt_actn_f pea,
1886: ben_per_in_ler pil,
1887: ben_prtt_enrt_ctfn_prvdd_f ecp
1888: where
1889: -- pen
1890: pen.person_id=p_person_id