DBA Data[Home] [Help]

APPS.PO_DOCUMENT_FUNDS_GRP SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 1290

    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;
Line: 1305

    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;