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 PQH_ROLES

Line 1398: fnd_user usr , pqh_roles rls

1394: cursor c1(c_role_id in number) is
1395: SELECT pei.person_id person_id, ppf.full_name person_name ,
1396: usr.user_name user_name, usr.user_id user_id
1397: FROM per_people_extra_info pei , per_all_people_f ppf ,
1398: fnd_user usr , pqh_roles rls
1399: WHERE information_type = 'PQH_ROLE_USERS' and pei.person_id = ppf.person_id
1400: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date
1401: and usr.employee_id = ppf.person_id
1402: and rls.role_id = to_number(nvl(pei.pei_information3,-1)) --to_number(pei.pei_information3)

Line 1408: from pqh_roles

1404: and rls.role_id = c_role_id
1405: and pei.person_id = p_person_id;
1406:
1407: cursor c2 is select role_id,role_name
1408: from pqh_roles
1409: where role_type_cd ='CWB';
1410:
1411: l_package varchar2(80) := g_package||'.is_in_comp_manager_role';
1412: