DBA Data[Home] [Help]

APPS.PON_CONTERMS_UTL_GRP dependencies on HZ_PARTIES

Line 85: hz_parties user_parties,

81: into
82: l_auction_status
83: from
84: fnd_user,
85: hz_parties user_parties,
86: hz_parties company_parties,
87: hz_relationships,
88: hz_code_assignments,
89: pon_auction_headers_all auction

Line 86: hz_parties company_parties,

82: l_auction_status
83: from
84: fnd_user,
85: hz_parties user_parties,
86: hz_parties company_parties,
87: hz_relationships,
88: hz_code_assignments,
89: pon_auction_headers_all auction
90: where

Line 100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'

96: and hz_relationships.relationship_code = 'EMPLOYEE_OF'
97: and hz_relationships.start_date <= SYSDATE
98: and hz_relationships.end_date >= SYSDATE
99: and hz_code_assignments.owner_table_id = company_parties.party_id
100: and hz_code_assignments.owner_table_name = 'HZ_PARTIES'
101: and hz_code_assignments.class_category = 'POS_PARTICIPANT_TYPE'
102: and hz_code_assignments.class_code = 'ENTERPRISE'
103: and auction.auction_header_id = l_auction_header_id
104: and auction.draft_locked = 'Y'