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_PTNL_LER_FOR_PER

Line 196: select ler_id from ben_ptnl_ler_for_per

192: SELECT 1 FROM fnd_sessions
193: where session_id = c_session_id;
194:
195: cursor c_get_ler_id is
196: select ler_id from ben_ptnl_ler_for_per
197: where business_group_id = p_business_group_id
198: and person_id = p_person_id
199: and ptnl_ler_for_per_stat_cd ='UNPROCD'
200: and ler_id not in (select ler_id from ben_ler_f where name

Line 215: from ben_ptnl_ler_for_per ptnl,

211:
212: cursor c_get_unproc_lf_evt
213: is
214: select le.name
215: from ben_ptnl_ler_for_per ptnl,
216: ben_ler_f le
217: where ptnl.business_group_id = p_business_group_id
218: and ptnl.person_id = p_person_id
219: and ptnl_ler_for_per_stat_cd ='UNPROCD'