DBA Data[Home] [Help]

APPS.AMW_LOAD_KEY_ACC_DATA dependencies on FND_USER

Line 118: from fnd_user

114: CURSOR c_requestor_id IS
115: SELECT party_id
116: FROM amw_employees_current_v
117: WHERE employee_id = (select employee_id
118: from fnd_user
119: where user_id = p_user_id)
120: AND rownum = 1;
121:
122: cursor c_key_acc_exists(p_process_id in number, p_natural_account_id in number) is

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

456: ,p_user_id in number
457: ) return varchar2
458: is
459: cursor c_get_user_name is
460: select user_name from fnd_user where user_id=p_user_id;
461:
462: l_has_access varchar2(15) := 'T';
463: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
464: l_security_switch VARCHAR2 (2);

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

459: cursor c_get_user_name is
460: select user_name from fnd_user where user_id=p_user_id;
461:
462: l_has_access varchar2(15) := 'T';
463: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
464: l_security_switch VARCHAR2 (2);
465: begin
466: open c_get_user_name;
467: fetch c_get_user_name into l_user_name;