APPS.ZX_TDS_UTILITIES_PKG dependencies on ZX_JURISDICTIONS_B

Line 530: p_tax_jurisdiction_code IN zx_jurisdictions_b.tax_jurisdiction_code%TYPE,

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

Line 543: FROM ZX_JURISDICTIONS_B

539: effective_from,
540: effective_to,
541: tax_regime_code,
542: tax
543: FROM ZX_JURISDICTIONS_B
544: WHERE tax_regime_code = p_tax_regime_code
545: AND tax = p_tax
546: AND tax_jurisdiction_code = p_tax_jurisdiction_code
547: AND (effective_from <= p_tax_determine_date AND

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,