APPS.PO_INVOICE_HOLD_CHECK SQL Statements

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

Line: 82

    SELECT NVL(pay_when_paid, 'N'),
           type_lookup_code
     INTO  x_pay_when_paid,
           l_type_lookup_code
    FROM   po_headers_all
    WHERE  po_header_id = p_po_header_id;

Line: 189

/*    SELECT NVL(pay_when_paid, 'N'),
           revision_num,
           type_lookup_code
    INTO   l_pay_when_paid,
           l_rev_num,
           l_type_lookup_code
    FROM   po_headers_all
    WHERE  po_header_id = p_po_header_id; */

Line: 205

    SELECT NVL(poh.pay_when_paid, 'N'),
           poh.revision_num,
           poh.type_lookup_code,
           Nvl(ps.deliverable_hold_flag, 'N')
    INTO   l_pay_when_paid,
           l_rev_num,
           l_type_lookup_code,
           l_deliverable_hold_flag
    FROM   po_doc_style_headers ps, po_headers_all poh
    WHERE poh.po_header_id = p_po_header_id
    AND poh.style_id = ps.style_id;

Line: 346

    SELECT deliverable_hold_flag
    INTO   x_render_deliverable_hold
    FROM   (SELECT DECODE(Nvl(ps.deliverable_hold_flag, 'N'),'N',Nvl(ph.pay_when_paid, 'N'),ps.deliverable_hold_flag) deliverable_hold_flag
            FROM   po_doc_style_headers ps,
                   po_headers_all ph
            WHERE  ph.po_header_id = p_po_header_id
                   AND ph.style_id = ps.style_id
            UNION
            SELECT DECODE(Nvl(ps.deliverable_hold_flag, 'N'),'N',Nvl(ph.pay_when_paid, 'N'),ps.deliverable_hold_flag) deliverable_hold_flag
            FROM   po_doc_style_headers ps,
                   po_headers_draft_all ph
            WHERE  ph.draft_id = p_po_header_id
                   AND ph.style_id = ps.style_id);