APPS.PON_AUCTION_INTERFACE_PKG dependencies on HZ_PARTIES

Line 203: hz_parties user_parties,

199: company_parties.party_id company_party_id
200: INTO i_draft_locked_by,
201: i_draft_locked_by_contact_id
202: FROM fnd_user,
203: hz_parties user_parties,
204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id

Line 204: hz_parties company_parties,

200: INTO i_draft_locked_by,
201: i_draft_locked_by_contact_id
202: FROM fnd_user,
203: hz_parties user_parties,
204: hz_parties company_parties,
205: hz_relationships,
206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id

Line 216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'

212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'
213: AND hz_relationships.start_date <= SYSDATE
214: AND hz_relationships.end_date >= SYSDATE
215: AND hz_code_assignments.owner_table_id = company_parties.party_id
216: AND hz_code_assignments.owner_table_name = 'HZ_PARTIES'
217: AND hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
218: AND hz_code_assignments.class_code = 'ENTERPRISE';
219:
220: logme(l_log_module, 'current user '||i_draft_locked_by|| 'user contact '||i_draft_locked_by_contact_id);