APPS.JA_CN_CFS_GENERATE_PKG SQL Statements

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

Line: 180

SELECT
  request_id
FROM
  fnd_concurrent_requests
WHERE parent_request_id=l_reqid_fsg;

Line: 190

SELECT
  currency_code
FROM
  gl_ledgers
WHERE
  ledger_id=p_ledger_id;

Line: 200

SELECT
  name
FROM
  hr_legal_entities
WHERE organization_id=l_legal_entity_id;

Line: 208

SELECT COMPANY_NAME
INTO L_COMPANY_NAME
FROM JA_CN_SYSTEM_PARAMETERS_ALL
WHERE LEGAL_ENTITY_ID= l_legal_entity_id;

Line: 386

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

Line: 411

      SELECT
        lookup_code
      INTO
        l_fsg_req_status_code
      FROM
        fnd_lookup_values
      WHERE lookup_type = 'CP_STATUS_CODE'
        AND view_application_id=0
        AND security_group_id=0
        AND meaning=l_fsg_req_status
        AND enabled_flag='Y'
        AND language = USERENV('LANG');

Line: 486

            SELECT
              lookup_code
            INTO
              l_cal_req_status_code
            FROM
              fnd_lookup_values
            WHERE lookup_type = 'CP_STATUS_CODE'
              AND view_application_id=0
              AND security_group_id=0
              AND meaning=l_cal_req_status
              AND enabled_flag='Y'
              AND language = USERENV('LANG');

Line: 539

                  SELECT
                    lookup_code
                  INTO
                    l_comb_req_status_code
                  FROM
                    fnd_lookup_values
                  WHERE lookup_type = 'CP_STATUS_CODE'
                    AND view_application_id=0
                    AND security_group_id=0
                    AND meaning=l_comb_req_status
                    AND enabled_flag='Y'
                    AND language = USERENV('LANG');