DBA Data[Home] [Help]

APPS.ICX_SEC dependencies on FND_RESPONSIBILITY_VL

Line 600: fnd_responsibility_vl a,

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
604: and b.start_date <= sysdate

Line 616: fnd_responsibility_vl a,

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
620: and b.start_date <= sysdate

Line 3134: fnd_responsibility_vl a,

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
3138: and (b.end_date is null or b.end_date > sysdate)

Line 4440: fnd_responsibility_vl c,

4436: select count(*)
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