APPS.PO_CLM_DOCUMENT_CONTROL_PVT dependencies on PO_LINES_ALL

Line 315: po_lines_all pol

311: AND NVL(frozen_flag,'N') = 'N'
312: )
313: OR EXISTS (SELECT 'open reference exists at line level'
314: FROM po_headers_all poh,
315: po_lines_all pol
316: WHERE poh.po_header_id = pol.po_header_id
317: AND (pol.from_header_id = p_doc_header_id
318: OR pol.contract_id = p_doc_header_id)
319: AND NVL(poh.frozen_flag,'N') = 'N'

Line 350: po_lines_all award_line

346: AND NVL(idv.frozen_flag,'N') = 'Y'
347: )
348: OR EXISTS (SELECT 'source IDV at line level not open'
349: FROM po_headers_all idv,
350: po_lines_all award_line
351: WHERE award_line.po_header_id = award.po_header_id
352: AND (award_line.from_header_id = idv.po_header_id
353: OR award_line.contract_id = idv.po_header_id)
354: AND NVL(idv.frozen_flag,'N') = 'Y'