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.BEN_CWB_RSGN_EMP dependencies on PER_PEOPLE_EXTRA_INFO

Line 1396: FROM per_people_extra_info pei , per_all_people_f ppf ,

1392: function is_in_comp_manager_role(p_person_id in number) return varchar2 is
1393: cursor c1(c_role_id in number) is
1394: SELECT pei.person_id person_id, ppf.full_name person_name ,
1395: usr.user_name user_name, usr.user_id user_id
1396: FROM per_people_extra_info pei , per_all_people_f ppf ,
1397: fnd_user usr , pqh_roles rls
1398: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
1399: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
1400: and usr.employee_id = ppf.person_id