DBA Data[Home] [Help]

APPS.MSC_X_WFNOTIFY_PKG dependencies on FND_USER

Line 16: fnd_user u

12: function validate_block_notification(p_user_name in varchar2, p_exception_type in number) return number is
13: cursor check_user(p_user in varchar2, p_excep_type number) is
14: select 1
15: from MSC_EXCEPTION_PREFERENCES ep,
16: fnd_user u
17: where ep.user_id = u.user_id
18: and u.user_name = p_user
19: and exception_type_lookup_code = p_excep_type
20: and rank > 0;