APPS.PON_AUCTION_PKG dependencies on POS_CONTACT_REQUESTS

Line 227: pos_contact_requests pcr

223: pbp.requested_supp_contact_name,
224: pcr.email_address rs_contact_email
225: -- lxchen
226: from pon_bidding_parties pbp,
227: pos_contact_requests pcr
228: where pbp.auction_header_id = x_auction_header_id and
229: pbp.requested_supplier_contact_id = pcr.contact_request_id (+)
230: union
231: select distinct trading_partner_name,

Line 3787: from pon_bidding_parties pbp, pos_contact_requests pcr

3783: pbp.vendor_site_id,
3784: pbp.requested_supplier_id,
3785: pbp.requested_supplier_contact_id,
3786: pcr.email_address rs_contact_email
3787: from pon_bidding_parties pbp, pos_contact_requests pcr
3788: where pbp.auction_header_id = x_auction_header_id
3789: and pbp.requested_supplier_contact_id = pcr.contact_request_id (+);
3790:
3791: CURSOR c_user_name IS

Line 6628: pos_contact_requests pcr

6624: pbp.requested_supplier_contact_id,
6625: pbp.requested_supp_contact_name,
6626: pcr.email_address rs_contact_email
6627: from pon_bidding_parties pbp,
6628: pos_contact_requests pcr
6629: where auction_header_id = x_auction_header_id
6630: and pbp.requested_supplier_contact_id = pcr.contact_request_id(+)
6631: and wf_item_key IS NULL;
6632: