APPS.PO_PA_INTEGRATION_GRP dependencies on PO_LINES_ALL

Line 163: FROM po_lines_all

159: -- Sql What : Gets the po line id for a given po line number and OU
160: -- Sql Why : To validate the PO line number
161: SELECT po_line_id
162: INTO p_po_line_id
163: FROM po_lines_all
164: WHERE line_num = p_po_line_num
165: AND po_header_id = p_po_header_id
166: AND org_id = p_org_id;
167:

Line 391: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;

387: FUNCTION is_rate_based_line (p_po_line_id IN NUMBER,
388: p_po_distribution_id IN NUMBER)
389: RETURN BOOLEAN IS
390:
391: l_po_line_id PO_LINES_ALL.po_line_id%TYPE;
392:
393: BEGIN
394:
395: IF p_po_line_id is null and p_po_distribution_id is null THEN

Line 532: FROM po_lines_all pol,

528: SELECT poh.po_header_id,
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: