DBA Data[Home] [Help]

APPS.ICX_SEC dependencies on FND_USER_RESP_GROUPS

Line 601: FND_USER_RESP_GROUPS b,

597:
598: select count(*) into l_count_resp_f
599: from FND_SECURITY_GROUPS_VL fsg,
600: fnd_responsibility_vl a,
601: FND_USER_RESP_GROUPS b,
602: FND_APPLICATION fa
603: where b.user_id = p_user_id
604: and b.start_date <= sysdate
605: and (b.end_date is null or b.end_date > sysdate)

Line 617: FND_USER_RESP_GROUPS b,

613:
614: select count(*) into l_count_resp_o
615: from FND_SECURITY_GROUPS_VL fsg,
616: fnd_responsibility_vl a,
617: FND_USER_RESP_GROUPS b,
618: FND_APPLICATION fa
619: where b.user_id = p_user_id
620: and b.start_date <= sysdate
621: and (b.end_date is null or b.end_date > sysdate)

Line 3135: FND_USER_RESP_GROUPS b

3131: select a.responsibility_name
3132: from
3133: --FND_SECURITY_GROUPS_VL fsg, -- mputman per 2018060
3134: fnd_responsibility_vl a,
3135: FND_USER_RESP_GROUPS b
3136: where b.user_id = c_user_id
3137: and b.start_date <= sysdate
3138: and (b.end_date is null or b.end_date > sysdate)
3139: and b.RESPONSIBILITY_id = a.responsibility_id

Line 4445: fnd_user_resp_groups d,

4441: INTO n_hits
4442: from FND_FORM_FUNCTIONS a,
4443: fnd_menu_entries_vl b,
4444: fnd_responsibility_vl c,
4445: fnd_user_resp_groups d,
4446: fnd_security_groups_vl e
4447: where d.user_id = l_anon_user_id
4448: AND a.function_id = p_func_id
4449: and b.function_id = a.function_id