2560: hr_locations_all loc_bill,
2561: fnd_territories_tl bill_territories_tl,
2562: hr_locations_all loc_ship,
2563: fnd_territories_tl ship_territories_tl,
2564: fnd_currencies_tl currency_tl ,
2565: pon_auc_doctypes doctypes,
2566: hz_parties hp1,
2567: hr_operating_units ou,
2568: hr_all_organization_units entity,
3715: pon_printing_pkg.get_display_rate(pacr.rate_dsp,pah.rate_type,pah.rate_date,pah.currency_code,bid_currency_code) display_rate
3716: FROM
3717: pon_auction_headers_all pah,
3718: pon_auction_currency_rates pacr ,
3719: fnd_currencies_tl ftl
3720: where
3721: pah.auction_header_id = p_auction_header_id
3722: AND pacr.auction_header_id = pah.auction_header_id
3723: and ftl.currency_code = pacr.bid_currency_code
3751: nvl2(pbp.rate_dsp, pon_printing_pkg.format_number(pbp.rate_dsp), null) as display_rate
3752: FROM
3753: pon_auction_headers_all pah,
3754: pon_bidding_parties pbp,
3755: fnd_currencies_tl ftl
3756: WHERE pah.auction_header_id = p_auction_header_id
3757: AND pbp.auction_header_id = pah.auction_header_id
3758: AND (l_is_buyer_negpdf = 'N')
3759: AND ftl.currency_code = pbp.bid_currency_code