DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_PF_SUPPLIER_VALUES

Line 7274: pon_pf_supplier_values ppsv,

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

Line 7840: -- delete data from pon_pf_supplier_values before

7836: WHERE auction_header_id = p_auction_header_id;
7837:
7838: -- clean up from any previous failures
7839:
7840: -- delete data from pon_pf_supplier_values before
7841: -- calling the pon_lrg_draft_to_ord_pf_copy procedure to populate it again
7842: -- Only for large auctions
7843:
7844: IF (l_large_neg_enabled_flag = 'Y') THEN

Line 7846: pon_pf_supplier_values

7842: -- Only for large auctions
7843:
7844: IF (l_large_neg_enabled_flag = 'Y') THEN
7845: DELETE FROM
7846: pon_pf_supplier_values
7847: WHERE
7848: auction_header_id = p_auction_header_id;
7849: END IF;
7850: