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_CONTINGENT_WORKER_API dependencies on PER_ROLES

Line 2783: from per_roles

2779: select
2780: role_id
2781: , object_version_number
2782: , end_date
2783: from per_roles
2784: where person_id = p_person_id
2785: and p_actual_termination_date
2786: between start_date
2787: and nvl(end_date, hr_api.g_eot);

Line 2791: from per_roles

2787: and nvl(end_date, hr_api.g_eot);
2788:
2789: cursor csr_chk_addl_rights is
2790: select role_id
2791: from per_roles
2792: where person_id = p_person_id
2793: and EMP_RIGHTS_FLAG = 'Y'
2794: and nvl(end_of_rights_date, hr_api.g_eot) > p_actual_termination_date;
2795: -- end fix 1370960

Line 3283: per_roles

3279: cursor csr_roles is
3280: select role_id
3281: ,object_version_number
3282: ,old_end_date from
3283: per_roles
3284: where person_id = p_person_id
3285: and end_date = p_actual_termination_date
3286: for update nowait;
3287: -- fix 1370960 end