240: pbp.requested_supp_contact_name,
241: pcr.email_address rs_contact_email
242: -- lxchen
243: from pon_bidding_parties pbp,
244: pos_contact_requests pcr
245: where pbp.auction_header_id = x_auction_header_id and
246: pbp.requested_supplier_contact_id = pcr.contact_request_id (+)
247: union
248: select distinct trading_partner_name,
4349: pbp.vendor_site_id,
4350: pbp.requested_supplier_id,
4351: pbp.requested_supplier_contact_id,
4352: pcr.email_address rs_contact_email
4353: from pon_bidding_parties pbp, pos_contact_requests pcr
4354: where pbp.auction_header_id = x_auction_header_id
4355: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
4356:
4357: CURSOR c_user_name IS
7228: pbp.requested_supplier_contact_id,
7229: pbp.requested_supp_contact_name,
7230: pcr.email_address rs_contact_email
7231: from pon_bidding_parties pbp,
7232: pos_contact_requests pcr
7233: where auction_header_id = x_auction_header_id
7234: and pbp.requested_supplier_contact_id = pcr.contact_request_id(+)
7235: and wf_item_key IS NULL;
7236: