APPS.PO_PRICE_BREAK_GRP dependencies on PO_LINE_LOCATIONS

Line 193: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */

189: v_ga_currency po_headers_all.currency_code%TYPE; -- FPI GA
190: v_conversion_rate po_headers_all.rate%TYPE; -- FPI GA
191: v_po_rate po_headers_all.rate%TYPE; -- FPI GA
192:
193: l_ship_to_org_id po_line_locations_all.ship_to_organization_id%TYPE; /* */
194:
195: l_dummy_var BOOLEAN; -- <2694908>
196:
197: l_progress varchar2(4);

Line 205: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;

201:
202: --
203: l_source_document_type PO_HEADERS.type_lookup_code%TYPE;
204: l_source_document_line_id PO_LINES.po_line_id%TYPE;
205: l_pricing_date PO_LINE_LOCATIONS.need_by_date%TYPE;
206: l_new_currency_price PO_LINES.unit_price%TYPE;
207: l_return_status varchar2(1);
208: l_api_name CONSTANT varchar2(30) := 'GET_PRICE_BREAK';
209: l_log_head CONSTANT varchar2(100) := g_log_head || l_api_name;

Line 254: , po_line_locations_all poll -- FPI GA

250: poll.unit_meas_lookup_code)
251: , poll.line_location_id -- SERVICES FPJ
252: FROM po_headers_all poh -- FPI GA
253: , po_lines_all pol -- FPI GA
254: , po_line_locations_all poll -- FPI GA
255: WHERE poh.po_header_id = p_source_document_header_id
256: and poh.po_header_id = pol.po_header_id
257: and pol.line_num = p_source_document_line_num
258: and pol.po_line_id = poll.po_line_id -- bug4043100

Line 914: l_price_break_id po_line_locations_all.line_location_id%TYPE; --

910: l_rate_type_out po_requisition_lines.rate_type%TYPE;
911: l_rate_date_out po_requisition_lines.rate_date%TYPE;
912: l_rate_out po_requisition_lines.rate%TYPE;
913: l_uom po_requisitions_interface.unit_of_measure%TYPE;
914: l_price_break_id po_line_locations_all.line_location_id%TYPE; --
915: l_progress VARCHAR2(3) := NULL;
916:
917: --
918: l_org_id po_requisitions_interface.org_id%TYPE;