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.HR_EX_EMPLOYEE_INTERNAL dependencies on PER_ROLES

Line 321: from per_roles

317: select
318: role_id
319: , object_version_number
320: , end_date
321: from per_roles
322: where person_id = p_person_id
323: and p_actual_termination_date
324: between start_date
325: and nvl(end_date, hr_api.g_eot);

Line 329: from per_roles

325: and nvl(end_date, hr_api.g_eot);
326:
327: cursor csr_chk_addl_rights( p_person_id in number) is
328: select role_id
329: from per_roles
330: where person_id = p_person_id
331: and EMP_RIGHTS_FLAG = 'Y'
332: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;
333: -- end fix 1370960