APPS.OKC_CA_UTIL_PVT dependencies on HZ_PARTIES

Line 182: return hz_parties.party_name%type

178: exception when others then return null;
179: end;
180:
181: function neg_supplier( p_auction_header_id in number)
182: return hz_parties.party_name%type
183: as
184: result hz_parties.party_name%type;
185: begin
186: select party_name into result

Line 184: result hz_parties.party_name%type;

180:
181: function neg_supplier( p_auction_header_id in number)
182: return hz_parties.party_name%type
183: as
184: result hz_parties.party_name%type;
185: begin
186: select party_name into result
187: from hz_parties p,
188: pon_bid_headers b

Line 187: from hz_parties p,

183: as
184: result hz_parties.party_name%type;
185: begin
186: select party_name into result
187: from hz_parties p,
188: pon_bid_headers b
189: where trading_partner_id = party_id
190: and bid_status IN ('ACTIVE','DISQUALIFIED')
191: and auction_header_id = p_auction_header_id;