APPS.PON_EVAL_TEAM_UTIL_PVT dependencies on HZ_PARTIES

Line 401: hz_parties hz

397: hz.party_name preparer_tp_name,
398: pad.message_suffix
399: FROM pon_auction_headers_all pah,
400: pon_auc_doctypes pad,
401: hz_parties hz
402: WHERE pah.auction_header_id = p_auction_header_id
403: AND pad.doctype_id = pah.doctype_id
404: AND hz.party_id = pah.trading_partner_id;
405:

Line 409: l_preparer_tp_name hz_parties.party_name%TYPE;

405:
406: l_language_code VARCHAR2(3);
407: l_doc_number pon_auction_headers_all.document_number%TYPE;
408: l_auction_title pon_auction_headers_all.auction_title%TYPE;
409: l_preparer_tp_name hz_parties.party_name%TYPE;
410: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
411: l_doc_type VARCHAR2(50);
412: l_member_user_name fnd_user.user_name%TYPE;
413: l_et_update_subject VARCHAR2(2000);

Line 912: hz_parties hz

908: pad.message_suffix
909: FROM pon_bid_headers pbh,
910: pon_auction_headers_all pah,
911: pon_auc_doctypes pad,
912: hz_parties hz
913: WHERE pbh.bid_number = p_bid_number
914: AND pah.auction_header_id = pbh.auction_header_id
915: AND pad.doctype_id = pah.doctype_id
916: AND hz.party_id = pah.trading_partner_id;

Line 962: l_preparer_tp_name hz_parties.party_name%TYPE;

958:
959: l_doc_number pon_auction_headers_all.document_number%TYPE;
960: l_auction_header_id pon_auction_headers_all.auction_header_id%TYPE;
961: l_auction_title pon_auction_headers_all.auction_title%TYPE;
962: l_preparer_tp_name hz_parties.party_name%TYPE;
963: l_msg_suffix pon_auc_doctypes.message_suffix%TYPE;
964: l_language_code VARCHAR2(3);
965: l_doc_type VARCHAR2(50);
966: l_eval_update_sub VARCHAR2(2000);