APPS.PON_BID_DEFAULTING_PKG dependencies on PON_PF_SUPPLIER_VALUES

Line 116: FROM pon_pf_supplier_values pfv

112:
113: UPDATE pon_bid_item_prices bl
114: SET bl.display_price_factors_flag =
115: nvl((SELECT 'Y'
116: FROM pon_pf_supplier_values pfv
117: WHERE pfv.auction_header_id = p_auc_header_id
118: AND pfv.line_number = bl.line_number
119: AND pfv.supplier_seq_number = p_supp_seq_number
120: AND nvl(pfv.value, 0) <> 0

Line 538: pon_pf_supplier_values pf,

534: sysdate, -- LAST_UPDATE_DATE
535: p_userid, -- LAST_UPDATED_BY
536: apf.pf_type -- PF_TYPE
537: FROM pon_price_elements apf,
538: pon_pf_supplier_values pf,
539: pon_bid_item_prices bl
540: WHERE apf.auction_header_id = p_auc_header_id
541: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
542: AND apf.display_to_suppliers_flag = 'Y'

Line 1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,

1689: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1690: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1691: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1692: p_userid IN pon_bid_headers.created_by%TYPE,
1693: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1694: p_rebid_flag IN VARCHAR2,
1695: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1696: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1697: ) IS

Line 1816: pon_pf_supplier_values pf,

1812: p_userid, -- LAST_UPDATED_BY
1813: apf.pf_type, -- PF_TYPE
1814: null -- OLD_BID_CURRENCY_VALUE
1815: FROM pon_price_elements apf,
1816: pon_pf_supplier_values pf,
1817: pon_bid_item_prices bl
1818: WHERE apf.auction_header_id = p_auc_header_id
1819: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
1820: AND apf.display_to_suppliers_flag = 'Y'