APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 1775: ( select 1 from pon_bid_payments_shipments where

1771: , pbip.progress_pymt_rate_percent
1772: , pbip.retainage_rate_percent
1773: , pbip.bid_curr_max_retainage_amt
1774: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
1775: ( select 1 from pon_bid_payments_shipments where
1776: auction_header_id = pbip.auction_header_id and
1777: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
1778: and bid_currency_price <> 0
1779: )

Line 2499: ( select 1 from pon_bid_payments_shipments where

2495: , pbip.progress_pymt_rate_percent
2496: , pbip.retainage_rate_percent
2497: , pbip.Bid_curr_max_retainage_amt
2498: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
2499: ( select 1 from pon_bid_payments_shipments where
2500: auction_header_id = pbip.auction_header_id and
2501: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
2502: and bid_currency_price <> 0
2503: )

Line 2646: pon_bid_payments_shipments bpys,

2642: x_user_id -- created_by
2643:
2644: FROM pon_auction_item_prices_all paip,
2645: pon_bid_item_prices pbip,
2646: pon_bid_payments_shipments bpys,
2647: pon_auc_payments_shipments apys,
2648: po_lines_interface pli,
2649: mtl_units_of_measure mtluom
2650: WHERE pbip.bid_number = p_bid_number and