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 1397: fnd_user usr , pqh_roles rls

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
1401: and rls.role_id = to_number(pei.pei_information3)

Line 1405: from pqh_roles

1401: and rls.role_id = to_number(pei.pei_information3)
1402: and nvl(pei.pei_information5,'Y')='Y'
1403: and rls.role_id = c_role_id;
1404: cursor c2 is select role_id,role_name
1405: from pqh_roles
1406: where role_type_cd ='CWB';
1407:
1408: l_package varchar2(80) := g_package||'.is_in_comp_manager_role';
1409: