APPS.AMW_LOAD_AP_DATA dependencies on FND_USER

Line 165: from fnd_user

161: CURSOR c_requestor_id IS
162: SELECT party_id
163: FROM amw_employees_current_v
164: WHERE employee_id = (select employee_id
165: from fnd_user
166: where user_id = p_user_id)
167: AND rownum = 1;
168:
169: CURSOR c_ap_exists (c_ap_name IN VARCHAR2) IS

Line 630: from fnd_user

626: )
627: is
628: cursor c_get_party_id is
629: select person_party_id
630: from fnd_user
631: where user_id=p_user_id;
632:
633: l_return_status varchar2(10);
634: l_msg_count number;

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

676: ,p_user_id in number
677: ) return varchar2
678: is
679: cursor c_get_user_name is
680: select user_name from fnd_user where user_id=p_user_id;
681:
682: l_has_access varchar2(15) := 'T';
683: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
684: l_security_switch VARCHAR2 (2);

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

679: cursor c_get_user_name is
680: select user_name from fnd_user where user_id=p_user_id;
681:
682: l_has_access varchar2(15) := 'T';
683: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
684: l_security_switch VARCHAR2 (2);
685: begin
686: open c_get_user_name;
687: fetch c_get_user_name into l_user_name;