[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT 'Y'
INTO l_amendment_inprogress
FROM po_requisition_headers_all
WHERE conformed_header_id = p_doc_level_id_tbl(i)
AND Nvl(authorization_status,'INCOMPLETE') NOT IN ('APPROVED','REJECTED')
AND ROWNUM = 1;
SELECT 'Y'
INTO l_award_mod_inprogress
FROM po_clmreq_line_awd_refs_v
WHERE requisition_header_id = p_doc_level_id_tbl(i)
AND Nvl(authorization_status,'INCOMPLETE') NOT IN ('APPROVED','REJECTED')
AND ROWNUM = 1;