DBA Data[Home] [Help]

APPS.ZX_TCM_EXT_SERVICES_PUB dependencies on ZX_STATUS_B

Line 34: p_tax_status_code OUT NOCOPY ZX_STATUS_B.TAX_STATUS_CODE%TYPE,

30: Procedure GET_DEFAULT_STATUS_RATES(
31: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
32: p_tax IN ZX_TAXES_B.TAX%TYPE,
33: p_date IN DATE,
34: p_tax_status_code OUT NOCOPY ZX_STATUS_B.TAX_STATUS_CODE%TYPE,
35: p_tax_rate_code OUT NOCOPY ZX_RATES_B.TAX_RATE_CODE%TYPE,
36: P_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
37:
38: /*

Line 61: CURSOR c_default_rate(c_status_code zx_status_b.tax_status_code%TYPE) IS

57: AND (p_date <= default_flg_effective_to OR default_flg_effective_to IS NULL);
58:
59:
60: -- get default rate code
61: CURSOR c_default_rate(c_status_code zx_status_b.tax_status_code%TYPE) IS
62: SELECT tax_rate_code
63: FROM zx_sco_rates
64: WHERE tax_regime_code = p_tax_regime_code
65: AND tax = p_tax