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.CSI_ASSIGN_ROLE_PUB dependencies on FND_USER

Line 13: from fnd_user_resp_groups fg, fnd_responsibility fr

9:
10: CURSOR get_user IS
11: SELECT us.user_name, (
12: select decode(count(*), 0, 'CSI_END_USER', 'CSI_NORMAL_USER')
13: from fnd_user_resp_groups fg, fnd_responsibility fr
14: where fg.user_id = us.user_id
15: and (fg.end_date is null or fg.end_date > sysdate)
16: and fr.responsibility_id = fg.responsibility_id
17: and fr.responsibility_key = 'ORACLE_SUPPORT'

Line 19: FROM fnd_user us

15: and (fg.end_date is null or fg.end_date > sysdate)
16: and fr.responsibility_id = fg.responsibility_id
17: and fr.responsibility_key = 'ORACLE_SUPPORT'
18: and rownum = 1 ) user_type
19: FROM fnd_user us
20: WHERE (us.end_date is null or us.end_date > sysdate)
21: AND EXISTS (select /*+ no_unnest */ null
22: from jtf_auth_principals_b p,
23: jtf_auth_principal_maps pr