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_BENEFITS_EIT dependencies on BEN_ENRT_RT

Line 705: CURSOR c_get_enrt_rt_id(c_elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type) is

701: AND pil.per_in_ler_id = chc.per_in_ler_id
702: --AND pil.ler_id = c_ler_id
703: AND pil.person_id = c_person_id;
704:
705: CURSOR c_get_enrt_rt_id(c_elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type) is
706: SELECT enrt_rt_id
707: FROM ben_enrt_rt
708: WHERE elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id;
709:

Line 707: FROM ben_enrt_rt

703: AND pil.person_id = c_person_id;
704:
705: CURSOR c_get_enrt_rt_id(c_elig_per_elctbl_chc_id ben_enrt_rt.elig_per_elctbl_chc_id%type) is
706: SELECT enrt_rt_id
707: FROM ben_enrt_rt
708: WHERE elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id;
709:
710: Nothing_to_do EXCEPTION;
711: ben_enrt_exists EXCEPTION;

Line 760: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;

756: l_eed date;
757: l_prtt_enrt_interim_id number;
758: l_Boolean BOOLEAN;
759: l_ses_exist BOOLEAN;
760: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
761:
762: cursor c_session(c_session_id fnd_sessions.session_id%type) IS
763: SELECT 1 FROM fnd_sessions
764: where session_id = c_session_id;