APPS.BEN_DETERMINE_COVERAGE dependencies on BEN_PRTT_ENRT_RSLT_F

Line 578: from ben_prtt_enrt_rslt_f pen,

574: /*
575: cursor c_det_crnt_enrt(l_rslt_id number) is
576: select pen.bnft_amt,
577: pen.bnft_ordr_num
578: from ben_prtt_enrt_rslt_f pen,
579: ben_elig_per_elctbl_chc epe
580: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
581: and epe.prtt_enrt_rslt_id = l_rslt_id
582: and pen.prtt_enrt_rslt_id = l_rslt_id;

Line 734: FROM ben_prtt_enrt_rslt_f pen,

730: cursor c_cf_bnft_result(cv_effective_date date) is
731: SELECT pen.prtt_enrt_rslt_id,
732: pen.bnft_amt,
733: pen.bnft_ordr_num
734: FROM ben_prtt_enrt_rslt_f pen,
735: ben_ler_f ler
736: WHERE pen.ler_id = ler.ler_id
737: AND pen.person_id = p_person_id
738: AND pen.business_group_id = p_business_group_id

Line 1790: from ben_prtt_enrt_rslt_f

1786: cursor c_current_enrt(cv_effective_date date) is -- FONM
1787: select bnft_ordr_num,
1788: bnft_amt,
1789: 'Y'
1790: from ben_prtt_enrt_rslt_f
1791: where business_group_id = l_business_group_id
1792: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1793: between enrt_cvg_strt_dt
1794: and enrt_cvg_thru_dt

Line 1808: from ben_prtt_enrt_rslt_f

1804: cursor c_current_enrt_sspndd(cv_effective_date date) is -- FONM
1805: select bnft_ordr_num,
1806: bnft_amt,
1807: 'Y'
1808: from ben_prtt_enrt_rslt_f
1809: where business_group_id = l_business_group_id
1810: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1811: between enrt_cvg_strt_dt
1812: and enrt_cvg_thru_dt

Line 1827: from ben_prtt_enrt_rslt_f

1823: --
1824: /*ENH*/
1825: cursor c_current_enrt_in_pl_typ(c_pl_typ_id number,cv_effective_date date) is -- FONM
1826: select pl_id,oipl_id
1827: from ben_prtt_enrt_rslt_f
1828: where business_group_id = l_business_group_id
1829: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1830: between enrt_cvg_strt_dt
1831: and enrt_cvg_thru_dt

Line 1840: from ben_prtt_enrt_rslt_f

1836: and c_pl_typ_id = pl_typ_id ;
1837: --
1838: cursor c_current_enrt_in_pln( c_pl_id number,cv_effective_date date ) is -- FONM
1839: select pl_id,oipl_id
1840: from ben_prtt_enrt_rslt_f
1841: where business_group_id = l_business_group_id
1842: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1843: between enrt_cvg_strt_dt
1844: and enrt_cvg_thru_dt

Line 1853: from ben_prtt_enrt_rslt_f

1849: and c_pl_id = pl_id ;
1850: --
1851: cursor c_current_enrt_in_oipl( c_oipl_id number, cv_effective_date date ) is -- FONM
1852: select pl_id,oipl_id
1853: from ben_prtt_enrt_rslt_f
1854: where business_group_id = l_business_group_id
1855: and cv_effective_date -- FONM nvl(p_lf_evt_ocrd_dt,p_effective_date)
1856: between enrt_cvg_strt_dt
1857: and enrt_cvg_thru_dt

Line 1869: from ben_prtt_enrt_rslt_f pen,

1865: cursor c_current_enb(c_pl_id number,c_oipl_id number, cv_effective_date date ) is -- FONM
1866: select
1867: pen.bnft_amt,
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

Line 1924: ben_prtt_enrt_rslt_f pen,

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

Line 1997: FROM ben_prtt_enrt_rslt_f pen

1993: cursor c_get_prev_bnft(cv_effective_date date) is
1994: SELECT pen.prtt_enrt_rslt_id,
1995: pen.bnft_amt,
1996: pen.bnft_ordr_num
1997: FROM ben_prtt_enrt_rslt_f pen
1998: WHERE pen.prtt_enrt_rslt_id = l_epe.prtt_enrt_rslt_id
1999: and pen.business_group_id = l_epe.business_group_id
2000: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2001: AND pen.effective_end_date = hr_api.g_eot

Line 2050: FROM ben_prtt_enrt_rslt_f pen

2046: p_pgm_id number,
2047: p_pl_id number,
2048: p_oipl_id number) is
2049: SELECT null
2050: FROM ben_prtt_enrt_rslt_f pen
2051: WHERE pen.per_in_ler_id = p_pil_id
2052: AND pen.sspndd_flag = 'Y'
2053: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2054: AND Nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)