DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_BIDDING_PARTIES

Line 5086: pon_bidding_parties pbp

5082: p_user_id, -- LAST_UPDATED_BY
5083: sysdate, -- LAST_UPDATE_DATE
5084: p_login_id -- LAST_UPDATE_LOGIN
5085: FROM
5086: pon_bidding_parties pbp
5087: WHERE
5088: pbp.auction_header_id = p_auction_header_id AND
5089: (SELECT
5090: COUNT(trading_partner_id)

Line 8164: pon_bidding_parties pbp,

8160: sum(decode(ppe.pricing_basis, 'FIXED_AMOUNT', Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y', -ppsv.Value,ppsv.Value), 0)) fixed_amount,
8161: 1 + sum(decode(ppe.pricing_basis, 'PERCENTAGE', Decode(Nvl(ppe.negative_cost_factor_flag,'N'),'Y', -ppsv.Value/100,ppsv.Value/100), 0)) percentage
8162: from
8163: pon_auction_item_prices_all paip,
8164: pon_bidding_parties pbp,
8165: pon_pf_supplier_values ppsv,
8166: pon_price_elements ppe
8167: where
8168: paip.auction_header_id = p_auction_header_id and

Line 9454: FROM pon_bidding_parties

9450: auction_header_id = p_auction_header_id;
9451:
9452: SELECT COUNT(auction_header_id)
9453: INTO l_invitees_count
9454: FROM pon_bidding_parties
9455: WHERE auction_header_id = p_auction_header_id;
9456:
9457: IF (FND_LOG.level_statement >= FND_LOG.g_current_runtime_level) THEN --{
9458: FND_LOG.string(log_level => FND_LOG.level_statement,