APPS.FND_OAM_USER_INFO dependencies on FND_USER

Line 47: from fnd_user u

43: nvl(u.customer_id, -1), nvl(u.supplier_id, -1),
44: user_guid
45: into v_user_id, v_employee_id, v_customer_id,
46: v_supplier_id, user_guid
47: from fnd_user u
48: where upper(user_name) = upper(p_username);
49: exception
50: when no_data_found then
51: v_employee_id := -1;

Line 67: fnd_user usr,

63: per.email_address,
64: usr.fax
65: INTO full_name, phone, email, fax
66: FROM
67: fnd_user usr,
68: per_all_people_f per
69: WHERE
70: trunc(SYSDATE) between per.effective_start_date
71: and per.effective_end_date

Line 85: fnd_user usr,

81: hz.email_address,
82: usr.fax
83: INTO suffix, first_name, last_name, email, fax
84: FROM
85: fnd_user usr,
86: hz_parties hz
87: WHERE
88: (hz.party_id = usr.customer_id
89: OR hz.party_id = usr.supplier_id)