APPS.PO_PA_INTEGRATION_GRP dependencies on PO_HEADERS_ALL

Line 142: FROM po_headers_all

138: -- Sql What : Gets the po header id for a given po number and OU
139: -- Sql Why : To validate the PO number
140: SELECT po_header_id
141: INTO p_po_header_id
142: FROM po_headers_all
143: WHERE segment1 = p_po_number
144: AND org_id = p_org_id;
145:
146: Exception

Line 493: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

489:
490: l_api_name CONSTANT VARCHAR2(30) := 'get_line_rate_info';
491: l_api_version CONSTANT NUMBER := 1.0;
492:
493: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
494: l_price NUMBER := null;
495: l_distribution_id PO_DISTRIBUTIONS_ALL.po_distribution_id%TYPE;
496: l_rate PO_DISTRIBUTIONS_ALL.rate%TYPE;
497: l_rate_date PO_DISTRIBUTIONS_ALL.rate_date%TYPE;

Line 533: po_headers_all poh

529: poh.vendor_id
530: INTO l_po_header_id,
531: x_vendor_id
532: FROM po_lines_all pol,
533: po_headers_all poh
534: WHERE pol.po_header_id = poh.po_header_id
535: AND pol.po_line_id = p_po_line_id;
536:
537: Exception