DBA Data[Home] [Help]

APPS.PON_AUCTION_PO_PKG dependencies on PON_PRICE_ELEMENT_TYPES_TL

Line 612: x_price_element_name pon_price_element_types_tl.name%TYPE;

608: newline varchar2(256);
609: tab varchar2(256);
610: x_item_description pon_auction_item_prices_all.item_description%TYPE;
611: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
612: x_price_element_name pon_price_element_types_tl.name%TYPE;
613: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
614: x_negative_cost_factor_flag pon_bid_price_elements.NEGATIVE_COST_FACTOR_FLAG%TYPE;
615: x_pricing_basis_display varchar2(2000);
616: x_msg_suffix VARCHAR2(3) := '';

Line 625: FROM pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv

621: SELECT ppet.name,
622: flv.meaning,
623: pbpe.bid_currency_value,
624: pbpe.NEGATIVE_COST_FACTOR_FLAG
625: FROM pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv
626: WHERE pbpe.bid_number = p_bid_number and
627: pbpe.auction_header_id = p_auction_header_id and
628: pbpe.line_number = p_line_number and
629: pbpe.price_element_type_id <> -10 and