APPS.PON_AUCTION_PO_PKG dependencies on PON_PRICE_ELEMENT_TYPES_TL

Line 474: x_price_element_name pon_price_element_types_tl.name%TYPE;

470: newline varchar2(256);
471: tab varchar2(256);
472: x_item_description pon_auction_item_prices_all.item_description%TYPE;
473: x_has_price_elements_flag pon_auction_item_prices_all.has_price_elements_flag%TYPE;
474: x_price_element_name pon_price_element_types_tl.name%TYPE;
475: x_bidValue pon_bid_price_elements.bid_currency_value%TYPE;
476: x_pricing_basis_display varchar2(2000);
477: x_msg_suffix VARCHAR2(3) := '';
478: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

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

481:
482: SELECT ppet.name,
483: flv.meaning,
484: pbpe.bid_currency_value
485: FROM pon_bid_price_elements pbpe, pon_price_element_types_tl ppet, fnd_lookup_values flv
486: WHERE pbpe.bid_number = p_bid_number and
487: pbpe.auction_header_id = p_auction_header_id and
488: pbpe.line_number = p_line_number and
489: pbpe.price_element_type_id <> -10 and