DBA Data[Home] [Help]

APPS.PO_DOCUMENT_ACTION_AUTH SQL Statements

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

Line: 196

        SELECT org_id INTO l_org_id
        FROM  po_headers_all poh
        WHERE poh.po_header_id =  p_action_ctl_rec.document_id ;
Line: 413

      SELECT nvl(poh.encumbrance_required_flag, 'N')
      INTO l_enc_flag
      FROM po_headers_all poh
      WHERE po_header_id = p_action_ctl_rec.document_id;