APPS.AMW_LOAD_RCM_ORG_DATA dependencies on FND_USER

Line 323: from fnd_user

319: CURSOR c_requestor_id IS
320: SELECT party_id
321: FROM amw_employees_current_v
322: WHERE employee_id = (select employee_id
323: from fnd_user
324: where user_id = p_user_id)
325: AND rownum = 1;
326:
327: CURSOR c_risk_exists (c_risk_name IN VARCHAR2) IS

Line 3115: from fnd_user

3111: )
3112: is
3113: cursor c_get_party_id is
3114: select person_party_id
3115: from fnd_user
3116: where user_id=p_user_id;
3117:
3118: l_return_status varchar2(10);
3119: l_msg_count number;

Line 3165: select user_name from fnd_user where user_id=p_user_id;

3161: ,p_user_id in number
3162: ) return varchar2
3163: is
3164: cursor c_get_user_name is
3165: select user_name from fnd_user where user_id=p_user_id;
3166:
3167: l_has_access varchar2(15) := 'T';
3168: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
3169: l_security_switch VARCHAR2 (2);

Line 3168: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100

3164: cursor c_get_user_name is
3165: select user_name from fnd_user where user_id=p_user_id;
3166:
3167: l_has_access varchar2(15) := 'T';
3168: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
3169: l_security_switch VARCHAR2 (2);
3170: begin
3171: open c_get_user_name;
3172: fetch c_get_user_name into l_user_name;