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 4441: fnd_user_resp_groups d,

4437: INTO n_hits
4438: from FND_FORM_FUNCTIONS a,
4439: fnd_menu_entries_vl b,
4440: fnd_responsibility_vl c,
4441: fnd_user_resp_groups d,
4442: fnd_security_groups_vl e
4443: where d.user_id = l_anon_user_id
4444: AND a.function_id = p_func_id
4445: and b.function_id = a.function_id