APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 554: from ben_prtt_enrt_rslt_f pen,

550: /*
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;

Line 710: FROM ben_prtt_enrt_rslt_f pen

706: cursor c_cf_bnft_result(cv_effective_date date) is
707: SELECT pen.prtt_enrt_rslt_id,
708: pen.bnft_amt,
709: pen.bnft_ordr_num
710: FROM ben_prtt_enrt_rslt_f pen
711: WHERE pen.person_id = p_person_id
712: AND pen.business_group_id = p_business_group_id
713: AND pen.prtt_enrt_rslt_stat_cd IS NULL
714: AND pen.effective_end_date = hr_api.g_eot

Line 1751: from ben_prtt_enrt_rslt_f

1747: cursor c_current_enrt(cv_effective_date date) is -- FONM
1748: select bnft_ordr_num,
1749: bnft_amt,
1750: 'Y'
1751: from ben_prtt_enrt_rslt_f
1752: where business_group_id = l_business_group_id
1753: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1754: between enrt_cvg_strt_dt
1755: and enrt_cvg_thru_dt

Line 1769: from ben_prtt_enrt_rslt_f

1765: cursor c_current_enrt_sspndd(cv_effective_date date) is -- FONM
1766: select bnft_ordr_num,
1767: bnft_amt,
1768: 'Y'
1769: from ben_prtt_enrt_rslt_f
1770: where business_group_id = l_business_group_id
1771: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1772: between enrt_cvg_strt_dt
1773: and enrt_cvg_thru_dt

Line 1788: from ben_prtt_enrt_rslt_f

1784: --
1785: /*ENH*/
1786: cursor c_current_enrt_in_pl_typ(c_pl_typ_id number,cv_effective_date date) is -- FONM
1787: select pl_id,oipl_id
1788: from ben_prtt_enrt_rslt_f
1789: where business_group_id = l_business_group_id
1790: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1791: between enrt_cvg_strt_dt
1792: and enrt_cvg_thru_dt

Line 1801: from ben_prtt_enrt_rslt_f

1797: and c_pl_typ_id = pl_typ_id ;
1798: --
1799: cursor c_current_enrt_in_pln( c_pl_id number,cv_effective_date date ) is -- FONM
1800: select pl_id,oipl_id
1801: from ben_prtt_enrt_rslt_f
1802: where business_group_id = l_business_group_id
1803: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1804: between enrt_cvg_strt_dt
1805: and enrt_cvg_thru_dt

Line 1814: from ben_prtt_enrt_rslt_f

1810: and c_pl_id = pl_id ;
1811: --
1812: cursor c_current_enrt_in_oipl( c_oipl_id number, cv_effective_date date ) is -- FONM
1813: select pl_id,oipl_id
1814: from ben_prtt_enrt_rslt_f
1815: where business_group_id = l_business_group_id
1816: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1817: between enrt_cvg_strt_dt
1818: and enrt_cvg_thru_dt

Line 1830: from ben_prtt_enrt_rslt_f pen,

1826: cursor c_current_enb(c_pl_id number,c_oipl_id number, cv_effective_date date ) is -- FONM
1827: select
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

Line 1884: ben_prtt_enrt_rslt_f pen,

1880: p_person_id in number,
1881: cv_effective_date in date ) is -- FONM
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