APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG SQL Statements

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

Line: 99

    SELECT formula_id,
           formula_type_code,
           taxable_basis_type_code,
           base_rate_modifier,
           cash_discount_appl_flag,
           volume_discount_appl_flag,
           trading_discount_appl_flag,
           transfer_charge_appl_flag,
           transport_charge_appl_flag,
           insurance_charge_appl_flag,
           other_charge_appl_flag
      FROM zx_sco_formula
     WHERE formula_code = c_formula_code
       AND effective_from <= c_tax_date
       AND (effective_to >= c_tax_date OR
            effective_to IS NULL )
       AND enabled_flag = 'Y';

Line: 118

    SELECT compounding_tax,
           compounding_tax_regime_code,
           compounding_type_code,
           enforce_compounding_flag
      FROM zx_formula_details
     WHERE formula_id = c_formula_id;

Line: 128

    SELECT tax_id FROM ZX_SCO_TAXES
     WHERE tax = c_tax
       AND tax_regime_code = c_tax_regime_code;

Line: 134

    SELECT NVL(ADJ_FOR_ADHOC_AMT_CODE,'TAXABLE_BASIS'),
           NVL(ALLOW_ADHOC_TAX_RATE_FLAG, 'N')
      FROM ZX_RATES_B
     WHERE TAX_RATE_ID = c_tax_rate_id;

Line: 141

    SELECT taxable_basis_formula_code
      FROM zx_rates_b
     WHERE tax_rate_id = c_tax_rate_id;

Line: 384

             ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag = 'Y'
        THEN

          IF (g_level_statement >= g_current_runtime_level ) THEN
            FND_LOG.STRING(g_level_statement,
                           'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
                           'Case 2 ... Do Nothing');

Line: 1198

             ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag = 'Y'
        THEN
          IF (g_level_statement >= g_current_runtime_level ) THEN
            FND_LOG.STRING(g_level_statement,
                           'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
                           'Case 3 : Partner Tax Line ... Do Nothing');

Line: 1292

        WHEN NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Delete_Flag,'N') <> 'Y' AND
             ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_provider_id IS NULL AND
             (NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Freeze_Until_Overridden_Flag,'N') <> 'Y' OR
              NVL(ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).COPIED_FROM_OTHER_DOC_FLAG,'N') <> 'Y')
             OR
             (ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).tax_event_type_code = 'OVERRIDE_TAX' AND
              ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).Recalc_Required_Flag = 'Y')
        THEN
          IF (g_level_statement >= g_current_runtime_level ) THEN
            FND_LOG.STRING(g_level_statement,
                           'ZX.PLSQL.ZX_TDS_TAXABLE_BASIS_DETM_PKG.Get_taxable_basis',
                           'Case 8 ... Updating columns');

Line: 1600

  SELECT inclusive_tax_flag
    FROM zx_rates_b
   WHERE tax_rate_id = c_tax_rate_id;

Line: 1606

  SELECT inclusive_tax_flag
    FROM zx_party_tax_profile
   WHERE party_tax_profile_id = c_ptp_id;