DBA Data[Home] [Help]

APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_JURISDICTIONS_B

Line 532: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

528: -------------------------------------------------------------------------
529: PROCEDURE get_jurisdiction_cache_info (
530: p_tax_regime_code IN zx_regimes_b.tax_regime_code%TYPE,
531: p_tax IN zx_taxes_b.tax%TYPE,
532: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
533: p_tax_determine_date IN DATE,
534: x_jurisdiction_rec OUT NOCOPY zx_jur_info_cache_rec_type,
535: p_return_status OUT NOCOPY VARCHAR2,
536: p_error_buffer OUT NOCOPY VARCHAR2) IS

Line 545: FROM ZX_JURISDICTIONS_B

541: effective_from,
542: effective_to,
543: tax_regime_code,
544: tax
545: FROM ZX_JURISDICTIONS_B
546: WHERE tax_regime_code = p_tax_regime_code
547: AND tax = p_tax
548: AND tax_jurisdiction_code = p_tax_jurisdiction_code;
549:

Line 884: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

880: --
881: PROCEDURE get_tax_rate_info (
882: p_tax_regime_code IN VARCHAR2,
883: p_tax IN VARCHAR2,
884: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,
885: p_tax_status_code IN VARCHAR2,
886: p_tax_rate_code IN VARCHAR2,
887: p_tax_determine_date IN DATE,
888: p_tax_class IN VARCHAR2,

Line 893: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE; -- for bug#5569426

889: p_tax_rate_rec OUT NOCOPY zx_rate_info_rec_type,
890: p_return_status OUT NOCOPY VARCHAR2,
891: p_error_buffer OUT NOCOPY VARCHAR2) IS
892:
893: l_tax_jurisdiction_code zx_jurisdictions_b.tax_jurisdiction_code%TYPE; -- for bug#5569426
894: CURSOR fetch_tax_rate_info_csr_jur IS
895: SELECT tax_regime_code,
896: tax,
897: tax_status_code,