APPS.CSI_ASSIGN_ROLE_PUB dependencies on FND_USER_RESP_GROUPS

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'