DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_BIDDING_PARTIES

Line 4241: pon_bidding_parties pbp

4237: p_user_id, -- LAST_UPDATED_BY
4238: sysdate, -- LAST_UPDATE_DATE
4239: p_login_id -- LAST_UPDATE_LOGIN
4240: FROM
4241: pon_bidding_parties pbp
4242: WHERE
4243: pbp.auction_header_id = p_auction_header_id AND
4244: (SELECT
4245: COUNT(trading_partner_id)

Line 7273: pon_bidding_parties pbp,

7269: sum(decode(ppe.pricing_basis, 'FIXED_AMOUNT', ppsv.value, 0)) fixed_amount,
7270: 1 + sum(decode(ppe.pricing_basis, 'PERCENTAGE', ppsv.value/100, 0)) percentage
7271: from
7272: pon_auction_item_prices_all paip,
7273: pon_bidding_parties pbp,
7274: pon_pf_supplier_values ppsv,
7275: pon_price_elements ppe
7276: where
7277: paip.auction_header_id = p_auction_header_id and

Line 8550: FROM pon_bidding_parties

8546: auction_header_id = p_auction_header_id;
8547:
8548: SELECT COUNT(auction_header_id)
8549: INTO l_invitees_count
8550: FROM pon_bidding_parties
8551: WHERE auction_header_id = p_auction_header_id;
8552:
8553: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
8554: FND_LOG.string(log_level => FND_LOG.level_statement,