eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_COVERAGE dependencies on HR_API

Line 740: --AND pen.effective_end_date = hr_api.g_eot

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
739: AND pen.prtt_enrt_rslt_stat_cd IS NULL
740: --AND pen.effective_end_date = hr_api.g_eot
741: --8567963
742: AND ((pen.effective_end_date = hr_api.g_eot
743: and ler.typ_cd <> 'SCHEDDU')
744: or ( cv_effective_date between pen.effective_start_date and pen.effective_end_date

Line 742: AND ((pen.effective_end_date = hr_api.g_eot

738: AND pen.business_group_id = p_business_group_id
739: AND pen.prtt_enrt_rslt_stat_cd IS NULL
740: --AND pen.effective_end_date = hr_api.g_eot
741: --8567963
742: AND ((pen.effective_end_date = hr_api.g_eot
743: and ler.typ_cd <> 'SCHEDDU')
744: or ( cv_effective_date between pen.effective_start_date and pen.effective_end_date
745: and ler.typ_cd = 'SCHEDDU'))
746: --8567963

Line 757: pen.enrt_cvg_thru_dt = hr_api.g_eot

753: pen.bnft_amt = p_val )
754: ----------Bug 7490759
755: AND (pen.sspndd_flag = 'N' --CFW
756: OR (pen.sspndd_flag = 'Y' and
757: pen.enrt_cvg_thru_dt = hr_api.g_eot
758: )
759: )
760: -- order by pen.enrt_cvg_strt_dt,decode(pen.sspndd_flag,'Y',1,2); --Bug 8453712
761: order by pen.enrt_cvg_strt_dt desc,decode(pen.sspndd_flag,'Y',1,2);

Line 2001: AND pen.effective_end_date = hr_api.g_eot

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
2002: AND cv_effective_date <= pen.enrt_cvg_thru_dt
2003: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
2004: AND NVL(l_epe.oipl_id,-1) = NVL(pen.oipl_id,-1)
2005: AND l_epe.pl_id = pen.pl_id

Line 2009: pen.enrt_cvg_thru_dt = hr_api.g_eot

2005: AND l_epe.pl_id = pen.pl_id
2006: AND NVL(l_epe.pgm_id,-1) = NVL(pen.pgm_id,-1)
2007: AND (pen.sspndd_flag = 'N'
2008: OR (pen.sspndd_flag = 'Y' and
2009: pen.enrt_cvg_thru_dt = hr_api.g_eot
2010: )
2011: )
2012: order by pen.enrt_cvg_strt_dt;
2013: l_get_prev_bnft c_get_prev_bnft%rowtype;

Line 2057: and pen.enrt_cvg_thru_dt = hr_api.g_eot

2053: AND pen.prtt_enrt_rslt_stat_cd IS NULL
2054: AND Nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2055: AND pen.pl_id = p_pl_id
2056: AND Nvl(pen.oipl_id,-1) = nvl(p_oipl_id,-1)
2057: and pen.enrt_cvg_thru_dt = hr_api.g_eot
2058: and pen.effective_end_date = hr_api.g_eot;
2059:
2060: l_chk_prev_sus_enr c_chk_prev_sus_enr%rowtype;
2061:

Line 2058: and pen.effective_end_date = hr_api.g_eot;

2054: AND Nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2055: AND pen.pl_id = p_pl_id
2056: AND Nvl(pen.oipl_id,-1) = nvl(p_oipl_id,-1)
2057: and pen.enrt_cvg_thru_dt = hr_api.g_eot
2058: and pen.effective_end_date = hr_api.g_eot;
2059:
2060: l_chk_prev_sus_enr c_chk_prev_sus_enr%rowtype;
2061:
2062: cursor c_get_cvg_rstr(p_prev_pil_id number) is

Line 2316: g_old_val := hr_api.g_number; /0;changed for 3497676 /

2312: close c_epe_in_pndg ;
2313: --
2314: -- put a row in fnd_sessions
2315: --
2316: g_old_val := hr_api.g_number; /*0;changed for 3497676 */
2317:
2318: /* when the 1st coverage is calculated as 0, the enrt bnft row was not
2319: being created because g_old_val is initialised to 0 */
2320: --