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 72: fnd_user usr,

68: per.email_address,
69: usr.fax
70: INTO full_name, email, fax
71: FROM
72: fnd_user usr,
73: per_all_people_f per
74: WHERE
75: trunc(SYSDATE) between per.effective_start_date
76: and per.effective_end_date

Line 107: fnd_user usr,

103: hz.email_address,
104: usr.fax
105: INTO suffix, first_name, last_name, email, fax
106: FROM
107: fnd_user usr,
108: hz_parties hz
109: WHERE
110: (hz.party_id = usr.customer_id
111: OR hz.party_id = usr.supplier_id)