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.GHR_TSP_PLAN_DESIGN dependencies on BEN_PRTT_ENRT_RSLT_F

Line 273: from ben_prtt_enrt_rslt_f

269:
270: -- Cursor to check if Employee has any open Benefits record for TSP
271: Cursor c_emp_in_tsp is
272: select 1
273: from ben_prtt_enrt_rslt_f
274: where person_id = p_person_id
275: and business_group_id = p_business_group_id
276: and pgm_id = p_pgm_id
277: and enrt_cvg_thru_dt = hr_api.g_eot

Line 284: from ben_prtt_enrt_rslt_f

280:
281: -- Cursor to get last TSP benefit record for the person
282: Cursor c_get_ee_last_tsp_enrt_rec is
283: select pl_id,pl_typ_id,ptip_id,prtt_enrt_rslt_id,oipl_id
284: from ben_prtt_enrt_rslt_f
285: where person_id = p_person_id
286: and business_group_id = p_business_group_id
287: and pgm_id = p_pgm_id
288: and ler_id = l_term_ler_id