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_CHC_CTFN dependencies on HR_API

Line 969: AND pen.effective_end_date = hr_api.g_eot

965: FROM ben_prtt_enrt_rslt_f pen
966: WHERE pen.person_id = p_person_id
967: AND pen.sspndd_flag = 'N'
968: AND pen.prtt_enrt_rslt_stat_cd IS NULL
969: AND pen.effective_end_date = hr_api.g_eot
970: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
971: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
972: -- AND pen.oipl_id IS NULL
973: AND p_pl_id = pen.pl_id

Line 990: AND pen.effective_end_date = hr_api.g_eot

986: FROM ben_prtt_enrt_rslt_f pen
987: WHERE pen.person_id = p_person_id
988: AND pen.sspndd_flag = 'N'
989: AND pen.prtt_enrt_rslt_stat_cd IS NULL
990: AND pen.effective_end_date = hr_api.g_eot
991: AND p_cvg_dt <= pen.enrt_cvg_thru_dt
992: AND pen.enrt_cvg_strt_dt < pen.effective_end_date
993: AND p_oipl_id = pen.oipl_id
994: AND (