APPS.FND_SOS_SERVICE dependencies on FND_USER

Line 44: enc_pwd FND_USER.ENCRYPTED_USER_PASSWORD%TYPE;

40: IS
41: ret VARCHAR2(1);
42: uid NUMBER;
43: sess_id NUMBER;
44: enc_pwd FND_USER.ENCRYPTED_USER_PASSWORD%TYPE;
45: pwd_expired varchar2(1);
46: p_lang fnd_languages.nls_language%type;
47:
48: BEGIN

Line 62: FROM fnd_user

58:
59:
60: SELECT user_id,description,ENCRYPTED_USER_PASSWORD
61: INTO user_id,description,enc_pwd
62: FROM fnd_user
63: WHERE UPPER(user_name)=UPPER(p_user_name);
64:
65: IF enc_pwd ='INVALID' THEN
66: user_status:='LOCKED';

Line 120: FROM fnd_user

116: SELECT session_id
117: FROM icx_sessions
118: WHERE user_id=
119: (SELECT user_id
120: FROM fnd_user
121: WHERE user_name=UPPER(p_user_name)
122: )
123: AND xsid =p_password
124: AND disabled_flag='N';