APPS.FND_OAM_USER_INFO dependencies on HZ_PARTIES

Line 108: hz_parties hz

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)
112: and usr.user_id = v_user_id;

Line 172: from HZ_PARTIES

168: is
169: begin
170: select PARTY_TYPE, PARTY_NAME
171: into P_PARTY_TYPE, P_PARTY_NAME
172: from HZ_PARTIES
173: where PARTY_ID = P_PARTY_ID;
174: end HZ_PARTY_ID_TO_NAME;
175:
176: --

Line 186: from HZ_PARTIES

182: is
183: begin
184: select PARTY_TYPE, PARTY_ID
185: into P_PARTY_TYPE, P_PARTY_ID
186: from HZ_PARTIES
187: where PARTY_NAME = P_PARTY_NAME;
188: end HZ_PARTY_NAME_TO_ID;
189:
190: --

Line 208: and rel.subject_table_name = 'HZ_PARTIES'

204: select distinct rel.subject_id
205: into l_cust_person_party_id
206: from hz_relationships rel
207: where rel.party_id = p_customer_id
208: and rel.subject_table_name = 'HZ_PARTIES'
209: and rel.subject_type = 'PERSON'
210: and rel.object_table_name = 'HZ_PARTIES'
211: and rel.object_type = 'ORGANIZATION';
212:

Line 210: and rel.object_table_name = 'HZ_PARTIES'

206: from hz_relationships rel
207: where rel.party_id = p_customer_id
208: and rel.subject_table_name = 'HZ_PARTIES'
209: and rel.subject_type = 'PERSON'
210: and rel.object_table_name = 'HZ_PARTIES'
211: and rel.object_type = 'ORGANIZATION';
212:
213:
214: return(L_CUST_PERSON_PARTY_ID);