DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_PF_SUPPLIER_VALUES

Line 8165: pon_pf_supplier_values ppsv,

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
8169: pbp.auction_header_id = paip.auction_header_id and

Line 8731: -- delete data from pon_pf_supplier_values before

8727: WHERE auction_header_id = p_auction_header_id;
8728:
8729: -- clean up from any previous failures
8730:
8731: -- delete data from pon_pf_supplier_values before
8732: -- calling the pon_lrg_draft_to_ord_pf_copy procedure to populate it again
8733: -- Only for large auctions
8734:
8735: IF (l_large_neg_enabled_flag = 'Y') THEN

Line 8737: pon_pf_supplier_values

8733: -- Only for large auctions
8734:
8735: IF (l_large_neg_enabled_flag = 'Y') THEN
8736: DELETE FROM
8737: pon_pf_supplier_values
8738: WHERE
8739: auction_header_id = p_auction_header_id;
8740: END IF;
8741: