APPS.AMW_LOAD_RC_DATA dependencies on FND_USER

Line 307: from fnd_user

303: CURSOR c_requestor_id IS
304: SELECT party_id
305: FROM amw_employees_current_v
306: WHERE employee_id = (select employee_id
307: from fnd_user
308: where user_id = p_user_id)
309: AND rownum = 1;
310:
311: CURSOR c_risk_exists (c_risk_name IN VARCHAR2) IS

Line 2857: from fnd_user

2853: )
2854: is
2855: cursor c_get_party_id is
2856: select person_party_id
2857: from fnd_user
2858: where user_id=p_user_id;
2859:
2860: l_return_status varchar2(10);
2861: l_msg_count number;

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

2903: ,p_user_id in number
2904: ) return varchar2
2905: is
2906: cursor c_get_user_name is
2907: select user_name from fnd_user where user_id=p_user_id;
2908:
2909: l_has_access varchar2(15) := 'T';
2910: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
2911: l_security_switch VARCHAR2 (2);

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

2906: cursor c_get_user_name is
2907: select user_name from fnd_user where user_id=p_user_id;
2908:
2909: l_has_access varchar2(15) := 'T';
2910: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
2911: l_security_switch VARCHAR2 (2);
2912: begin
2913: open c_get_user_name;
2914: fetch c_get_user_name into l_user_name;