APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 543: from ben_elig_per_elctbl_chc epe,

539: pil.ler_id,
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: --

Line 555: ben_elig_per_elctbl_chc epe

551: cursor c_det_crnt_enrt(l_rslt_id number) is
552: select pen.bnft_amt,
553: pen.bnft_ordr_num
554: from ben_prtt_enrt_rslt_f pen,
555: ben_elig_per_elctbl_chc epe
556: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
557: and epe.prtt_enrt_rslt_id = l_rslt_id
558: and pen.prtt_enrt_rslt_id = l_rslt_id;
559: --

Line 593: from ben_elig_per_elctbl_chc epe,

589: l_state c_state%rowtype;
590: --
591: cursor c_other_oipl_cvg is
592: select enb.val
593: from ben_elig_per_elctbl_chc epe,
594: ben_enrt_bnft enb
595: where epe.pl_id=l_epe.pl_id
596: and nvl(epe.pgm_id,-1)=nvl(l_epe.pgm_id,-1)
597: and epe.per_in_ler_id=l_epe.per_in_ler_id

Line 607: from ben_elig_per_elctbl_chc epe,

603: ;
604: --
605: cursor c_other_pl_cvg is
606: select enb.val
607: from ben_elig_per_elctbl_chc epe,
608: ben_enrt_bnft enb
609: where epe.ptip_id=l_epe.ptip_id
610: and nvl(epe.pgm_id,-1)=nvl(l_epe.pgm_id,-1)
611: and epe.per_in_ler_id=l_epe.per_in_ler_id

Line 621: from ben_elig_per_elctbl_chc epe,

617: ;
618: --
619: cursor c_other_pl_in_ptip_cvg(cv_effective_date date) is
620: select enb.val
621: from ben_elig_per_elctbl_chc epe,
622: ben_oipl_f oipl,
623: ben_oipl_f oipl2,
624: ben_enrt_bnft enb
625: where epe.ptip_id=l_epe.ptip_id

Line 671: from ben_elig_per_elctbl_chc epe

667: /*********************************
668: CODE PRIOR TO WWBUG: 2157614
669: cursor c_other_oipls_in_plan_type is
670: select 'Y'
671: from ben_elig_per_elctbl_chc epe
672: where epe.pl_typ_id=l_epe.pl_typ_id
673: and epe.pl_id<>l_epe.pl_id
674: and nvl(epe.pgm_id,-1)=nvl(l_epe.pgm_id,-1)
675: and epe.oipl_id is not null

Line 1593: from ben_elig_per_elctbl_chc epe,

1589: epe.business_group_id,
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: --

Line 1602: from ben_elig_per_elctbl_chc epe,

1598: --bug 1895846 to check for the pending work flow or suspended enrollment results
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' ;

Line 1832: ben_elig_per_elctbl_chc epe,

1828: pen.bnft_amt,
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