APPS.JA_CN_CFSSE_GENERATE_PKG SQL Statements

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

Line: 152

      SELECT request_id
        FROM fnd_concurrent_requests
       WHERE parent_request_id = l_reqid_fsg;

Line: 160

    SELECT
      currency_code
    FROM
      gl_ledgers
    WHERE
      ledger_id=p_ledger_id;

Line: 169

      SELECT hou.NAME
        FROM hr_organization_units hou
       WHERE hou.organization_id = p_legal_entity_id;

Line: 175

        SELECT COMPANY_NAME
        FROM JA_CN_SYSTEM_PARAMETERS_ALL
        WHERE LEGAL_ENTITY_ID= p_legal_entity_id;

Line: 250

            UPDATE 	FND_CONCURRENT_REQUESTS
            SET
              OUTPUT_FILE_TYPE = 'XML'
            WHERE
              REQUEST_ID = l_reqid_fsg;