APPS.MSC_X_USER_EXCEP_GEN dependencies on FND_USER

Line 191: fnd_user u

187: function validate_block_notification(p_user_name in varchar2, p_exception_type in number) return number is
188: cursor check_user(p_user in varchar2, p_excep_type number) is
189: select 1
190: from MSC_EXCEPTION_PREFERENCES ep,
191: fnd_user u
192: where ep.user_id = u.user_id
193: and u.user_name = p_user
194: and exception_type_lookup_code = p_excep_type
195: and rank > 0;

Line 659: FND.USER_NAME,

655: Procedure performSetUp is
656: cursor exceptionInfo is
657: select
658: ex.NAME,
659: FND.USER_NAME,
660: ex.WF_ITEM_TYPE,
661: ex.WF_PROCESS,
662: ex.WF_LAUNCH_FLAG,
663: translate(ex.NOTIFICATION_TEXT, fnd_global.local_chr(13) || fnd_global.local_chr(10), ' '),

Line 671: ,fnd_user fnd

667: ex.REFRESH_NUMBER
668: --ex.item_planner_ntf_flag
669: from
670: MSC_USER_EXCEPTIONS ex
671: ,fnd_user fnd
672: where
673: ex.exception_id = v_exception_id
674: and ex.CREATED_BY = fnd.USER_ID;
675:

Line 674: and ex.CREATED_BY = fnd.USER_ID;

670: MSC_USER_EXCEPTIONS ex
671: ,fnd_user fnd
672: where
673: ex.exception_id = v_exception_id
674: and ex.CREATED_BY = fnd.USER_ID;
675:
676: begin
677: v_user_id := FND_GLOBAL.USER_ID;
678: v_resp_id := FND_GLOBAL.RESP_ID;