APPS.FND_OAM_USER_INFO dependencies on HZ_PARTIES

Line 86: hz_parties hz

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

Line 150: from HZ_PARTIES

146: is
147: begin
148: select PARTY_TYPE, PARTY_NAME
149: into P_PARTY_TYPE, P_PARTY_NAME
150: from HZ_PARTIES
151: where PARTY_ID = P_PARTY_ID;
152: end HZ_PARTY_ID_TO_NAME;
153:
154: --

Line 164: from HZ_PARTIES

160: is
161: begin
162: select PARTY_TYPE, PARTY_ID
163: into P_PARTY_TYPE, P_PARTY_ID
164: from HZ_PARTIES
165: where PARTY_NAME = P_PARTY_NAME;
166: end HZ_PARTY_NAME_TO_ID;
167:
168: --

Line 179: and rel.subject_table_name = 'HZ_PARTIES'

175: select rel.subject_id
176: into l_cust_person_party_id
177: from hz_relationships rel
178: where rel.party_id = p_customer_id
179: and rel.subject_table_name = 'HZ_PARTIES'
180: and rel.subject_type = 'PERSON'
181: and rel.object_table_name = 'HZ_PARTIES'
182: and rel.object_type = 'ORGANIZATION';
183:

Line 181: and rel.object_table_name = 'HZ_PARTIES'

177: from hz_relationships rel
178: where rel.party_id = p_customer_id
179: and rel.subject_table_name = 'HZ_PARTIES'
180: and rel.subject_type = 'PERSON'
181: and rel.object_table_name = 'HZ_PARTIES'
182: and rel.object_type = 'ORGANIZATION';
183:
184: return(L_CUST_PERSON_PARTY_ID);
185: end GET_ORGANIZATION_ID;