APPS.IBU_HOME_PAGE_PVT dependencies on HZ_PARTIES

Line 193: FROM hz_parties p, fnd_user u

189: l_party_type VARCHAR2(30);
190: begin
191: SELECT p.party_type, party_id
192: INTO l_party_type, x_party_id
193: FROM hz_parties p, fnd_user u
194: WHERE u.user_id = p_user_id
195: AND p.party_id = u.customer_id;
196: return l_party_type;
197: exception

Line 250: FROM hz_parties

246: begin
247: l_company_id := get_company_id_from_user(p_user_id);
248: SELECT party_name
249: INTO l_company_name
250: FROM hz_parties
251: WHERE party_id = l_company_id;
252:
253: return l_company_name;
254: exception