APPS.PON_AUCTION_INTERFACE_PKG dependencies on HZ_RELATIONSHIPS

Line 205: hz_relationships,

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
209: AND hz_relationships.object_id = company_parties.party_id

Line 209: AND hz_relationships.object_id = company_parties.party_id

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
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'
213: AND hz_relationships.start_date <= SYSDATE

Line 210: AND hz_relationships.subject_id = user_parties.party_id

206: hz_code_assignments
207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'
213: AND hz_relationships.start_date <= SYSDATE
214: AND hz_relationships.end_date >= SYSDATE

Line 211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'

207: WHERE fnd_user.person_party_id = user_parties.party_id
208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
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

Line 212: AND hz_relationships.relationship_code = 'EMPLOYEE_OF'

208: AND fnd_user.user_id = p_buyer_id
209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
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'

Line 213: AND hz_relationships.start_date <= SYSDATE

209: AND hz_relationships.object_id = company_parties.party_id
210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
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'

Line 214: AND hz_relationships.end_date >= SYSDATE

210: AND hz_relationships.subject_id = user_parties.party_id
211: AND hz_relationships.relationship_type = 'POS_EMPLOYMENT'
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';