APPS.ZX_TDS_TAX_STATUS_DETM_PKG SQL Statements

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

Line: 14

PROCEDURE  update_det_tax_line(
             i                      IN      BINARY_INTEGER,
             p_status_result_id     IN      ZX_LINES.STATUS_RESULT_ID%TYPE,
             p_status_rec           IN      ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC);

Line: 247

         update_det_tax_line(i,
                             l_status_result_id,
                             l_status_rec);

Line: 299

    SELECT tax_status_id,
           tax_status_code,
           tax,
           tax_regime_code,
           effective_from,
           effective_to,
           Rule_Based_Rate_Flag,
           Allow_Rate_Override_Flag,
           Allow_Exemptions_Flag,
           Allow_Exceptions_Flag
--           Vat_Transaction_Type_Code
--           Default_Status_Flag,
--           default_flg_effective_from,
--           default_flg_effective_to
      FROM  ZX_SCO_STATUS_B_V
      WHERE Default_Status_Flag = 'Y'                              AND
            c_tax_determine_date >= DEFAULT_FLG_EFFECTIVE_FROM    AND
            (c_tax_determine_date <= DEFAULT_FLG_EFFECTIVE_TO OR
             DEFAULT_FLG_EFFECTIVE_TO IS NULL)                    AND
            TAX             = c_tax                               AND
            TAX_REGIME_CODE = c_tax_regime_code                   AND
            c_tax_determine_date >= EFFECTIVE_FROM                AND
            (c_tax_determine_date <= EFFECTIVE_TO OR
             EFFECTIVE_TO IS NULL)
         --AND rownum = 1;

Line: 508

PROCEDURE  update_det_tax_line(
             i                    IN     BINARY_INTEGER,
             p_status_result_id   IN     ZX_LINES.STATUS_RESULT_ID%TYPE,
             p_status_rec         IN     ZX_TDS_UTILITIES_PKG.ZX_STATUS_INFO_REC)
IS
BEGIN
  g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

Line: 518

                   'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.BEGIN',
                   'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(+)');

Line: 529

                   'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line.END',
                   'ZX_TDS_TAX_STATUS_DETM_PKG: update_det_tax_line(-)');

Line: 537

                     'ZX.PLSQL.ZX_TDS_TAX_STATUS_DETM_PKG.update_det_tax_line',
                      sqlcode || ': ' || SUBSTR(SQLERRM, 1, 80));

Line: 541

END update_det_tax_line;