APPS.FUN_CONTACTUS_EMAIL dependencies on HZ_PARTIES

Line 235: FROM fnd_user fu, hz_parties hp

231: ELSIF (l_customer_id IS NOT NULL) THEN
232: -- FND User is a customer
233: SELECT hp.party_name full_name, hp.email_address email_address
234: INTO p_full_name, p_email_address
235: FROM fnd_user fu, hz_parties hp
236: WHERE fu.customer_id IS NOT NULL
237: AND fu.customer_id = hp.party_id
238: AND fu.user_id = p_user_id;
239: