APPS.ZX_ON_FLY_TRX_UPGRADE_PKG SQL Statements

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

Line: 152

    SELECT distinct application_id
      FROM zx_validation_errors_gt
  UNION
    SELECT distinct other_doc_application_id
    FROM zx_validation_errors_gt;

Line: 256

    SELECT count(*) into l_count
      FROM zx_lines_det_factors
     WHERE application_id   = p_upg_trx_info_rec.application_id
       AND event_class_code = p_upg_trx_info_rec.event_class_code
       AND entity_code      = p_upg_trx_info_rec.entity_code
       AND trx_id           = p_upg_trx_info_rec.trx_id
       AND trx_line_id      = p_upg_trx_info_rec.trx_line_id
       AND trx_level_type   = p_upg_trx_info_rec.trx_level_type;

Line: 265

    SELECT count(*) into l_count
      FROM zx_lines_det_factors
     WHERE application_id   = p_upg_trx_info_rec.application_id
       AND event_class_code = p_upg_trx_info_rec.event_class_code
       AND entity_code      = p_upg_trx_info_rec.entity_code
       AND trx_id           = p_upg_trx_info_rec.trx_id;