APPS.ICX_SEC dependencies on FND_SECURITY_GROUPS_VL

Line 599: from FND_SECURITY_GROUPS_VL fsg,

595: -- Bug 3238722 fnd_web_sec will now return the login_id
596: /*
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

Line 615: from FND_SECURITY_GROUPS_VL fsg,

611: and (a.end_date is null or a.end_date > sysdate)
612: and b.SECURITY_GROUP_ID = fsg.SECURITY_GROUP_ID;
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

Line 3133: --FND_SECURITY_GROUPS_VL fsg, -- mputman per 2018060

3129:
3130: cursor responsibility is
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

Line 4446: fnd_security_groups_vl e

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
4450: and d.responsibility_application_id = c.application_id