APPS.ZX_TDS_TAXABLE_BASIS_DETM_PKG SQL Statements

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

Line: 106

       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: 126

         select compounding_tax,
                compounding_tax_regime_code,
                Compounding_Type_Code,
                enforce_compounding_flag
          from ZX_FORMULA_DETAILS
        where formula_id = c_formula_id;

Line: 136

        select tax_id from ZX_SCO_TAXES
         where tax = c_tax
           and tax_regime_code = c_tax_regime_code;

Line: 142

        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: 148

 SELECT taxable_basis_formula_code
   FROM zx_rates_b
  WHERE tax_rate_id = c_tax_rate_id;

Line: 357

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

      -- Do not perform taxable basis determination for provider calculated lines. Taxes
      -- calculated by providers cannot be compounded by taxes calculated by eTax and
      -- vice versa. Also, do not process tax lines which are marked for deletion.

      NULL;

Line: 1011

   END CASE;  -- Delete_Flag

Line: 1045

                  'update columns');

Line: 1062

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

      NULL;

Line: 1117

   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

        ZX_TDS_CALC_SERVICES_PUB_PKG.g_detail_tax_lines_tbl(i).taxable_basis_formula:=
                                                                 parameter_tbl(l_tax_id).formula_code;

Line: 1316

  END CASE; -- Delete_Flag

Line: 1373

 SELECT inclusive_tax_flag
   FROM zx_rates_b
  WHERE tax_rate_id = c_tax_rate_id;

Line: 1379

 SELECT inclusive_tax_flag
   FROM zx_party_tax_profile
  WHERE party_tax_profile_id = c_ptp_id;