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 542: pon_pf_supplier_values pf,

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

Line 1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,

1921: p_auc_header_id IN pon_auction_headers_all.auction_header_id%TYPE,
1922: p_bid_number IN pon_bid_headers.bid_number%TYPE,
1923: p_source_bid_num IN pon_bid_headers.bid_number%TYPE,
1924: p_userid IN pon_bid_headers.created_by%TYPE,
1925: p_supp_seq_number IN pon_pf_supplier_values.supplier_seq_number%TYPE,
1926: p_rebid_flag IN VARCHAR2,
1927: p_batch_start IN pon_bid_item_prices.line_number%TYPE,
1928: p_batch_end IN pon_bid_item_prices.line_number%TYPE
1929: ) IS

Line 2052: pon_pf_supplier_values pf,

2048: p_userid, -- LAST_UPDATED_BY
2049: apf.pf_type, -- PF_TYPE
2050: null -- OLD_BID_CURRENCY_VALUE
2051: FROM pon_price_elements apf,
2052: pon_pf_supplier_values pf,
2053: pon_bid_item_prices bl
2054: WHERE apf.auction_header_id = p_auc_header_id
2055: AND apf.pf_type = 'BUYER' -- only buyer pf that are to be displayed
2056: AND apf.display_to_suppliers_flag = 'Y'