APPS.AMW_LOAD_CTRL_DATA dependencies on FND_USER

Line 264: from fnd_user

260: CURSOR c_requestor_id IS
261: SELECT party_id
262: FROM amw_employees_current_v
263: WHERE employee_id = (select employee_id
264: from fnd_user
265: where user_id = p_user_id)
266: AND rownum = 1;
267:
268: CURSOR c_control_exists (c_control_name IN VARCHAR2) IS

Line 1287: from fnd_user

1283: )
1284: is
1285: cursor c_get_party_id is
1286: select person_party_id
1287: from fnd_user
1288: where user_id=p_user_id;
1289:
1290: l_return_status varchar2(10);
1291: l_msg_count number;

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

1333: ,p_user_id in number
1334: ) return varchar2
1335: is
1336: cursor c_get_user_name is
1337: select user_name from fnd_user where user_id=p_user_id;
1338:
1339: l_has_access varchar2(15) := 'T';
1340: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
1341: l_security_switch VARCHAR2 (2);

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

1336: cursor c_get_user_name is
1337: select user_name from fnd_user where user_id=p_user_id;
1338:
1339: l_has_access varchar2(15) := 'T';
1340: l_user_name varchar2(100); ---fnd_user.user_name colLength = 100
1341: l_security_switch VARCHAR2 (2);
1342: begin
1343: open c_get_user_name;
1344: fetch c_get_user_name into l_user_name;