95: auction.auction_status
96: into
97: l_auction_status
98: from
99: fnd_user,
100: hz_parties user_parties,
101: hz_parties company_parties,
102: hz_relationships,
103: hz_code_assignments,
102: hz_relationships,
103: hz_code_assignments,
104: pon_auction_headers_all auction
105: where
106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
103: hz_code_assignments,
104: pon_auction_headers_all auction
105: where
106: fnd_user.user_id = fnd_global.user_id()
107: and fnd_user.person_party_id = user_parties.party_id
108: and hz_relationships.object_id = company_parties.party_id
109: and hz_relationships.subject_id = user_parties.party_id
110: and hz_relationships.relationship_type = 'POS_EMPLOYMENT'
111: and hz_relationships.relationship_code = 'EMPLOYEE_OF'