APPS.PO_LINE_TYPES_SV dependencies on PO_LINES_ALL

Line 400: FROM po_lines_all

396: RETURN BOOLEAN
397: IS
398: CURSOR l_item_csr IS
399: SELECT item_id, org_id
400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;

Line 403: l_item_id PO_LINES_ALL.item_id%TYPE;

399: SELECT item_id, org_id
400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;
405:
406: BEGIN
407:

Line 404: l_org_id PO_LINES_ALL.org_id%TYPE;

400: FROM po_lines_all
401: WHERE po_header_id = p_po_header_id;
402:
403: l_item_id PO_LINES_ALL.item_id%TYPE;
404: l_org_id PO_LINES_ALL.org_id%TYPE;
405:
406: BEGIN
407:
408: OPEN l_item_csr;

Line 568: FROM po_lines_all POL

564: From po_requisition_lines_all PRL
565: WHERE PRL.line_type_id = p_line_type_id)
566:
567: OR EXISTS (SELECT 'PO Lines Exist'
568: FROM po_lines_all POL
569: WHERE POL.line_type_id = p_line_type_id)
570:
571: OR EXISTS (SELECT 'Archived PO Lines Exist'
572: FROM po_lines_archive_all POAL