APPS.PON_AUCTION_CREATE_PO_PKG dependencies on PON_BID_PAYMENTS_SHIPMENTS

Line 1930: ( select 1 from pon_bid_payments_shipments where

1926: , pbip.progress_pymt_rate_percent
1927: , pbip.retainage_rate_percent
1928: , pbip.bid_curr_max_retainage_amt
1929: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
1930: ( select 1 from pon_bid_payments_shipments where
1931: auction_header_id = pbip.auction_header_id and
1932: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
1933: and bid_currency_price <> 0
1934: )

Line 2977: ( select 1 from pon_bid_payments_shipments where

2973: , pbip.progress_pymt_rate_percent
2974: , pbip.retainage_rate_percent
2975: , pbip.Bid_curr_max_retainage_amt
2976: , decode(pbip.has_bid_payments_flag, 'Y', decode((select 1 from dual where exists
2977: ( select 1 from pon_bid_payments_shipments where
2978: auction_header_id = pbip.auction_header_id and
2979: bid_number= pbip.bid_number and bid_line_number=pbip.line_number
2980: and bid_currency_price <> 0
2981: )

Line 3159: pon_bid_payments_shipments bpys,

3155: x_user_id -- created_by
3156:
3157: FROM pon_auction_item_prices_all paip,
3158: pon_bid_item_prices pbip,
3159: pon_bid_payments_shipments bpys,
3160: pon_auc_payments_shipments apys,
3161: po_lines_interface pli,
3162: mtl_units_of_measure mtluom
3163: WHERE pbip.bid_number = p_bid_number and