APPS.ZX_VTX_USER_PKG dependencies on ZX_JURISDICTIONS_GT

Line 1071: delete from zx_jurisdictions_gt;

1067: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location Type: ',l_location_type);
1068: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location ID: ',to_char(p_bill_to_location_id));
1069: END IF;
1070:
1071: delete from zx_jurisdictions_gt;
1072: IF p_bill_to_location_id IS NOT NULL THEN
1073: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1074: p_location_id => p_bill_to_location_id,
1075: p_location_type => l_location_type,

Line 1769: FROM zx_jurisdictions_gt a

1765: ELSE
1766: BEGIN
1767: SELECT count(*)
1768: INTO l_jur_count
1769: FROM zx_jurisdictions_gt a
1770: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1771: AND a.tax = 'CITY'
1772: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1773: AND a.precedence_level = (SELECT max(b.precedence_level)

Line 1774: FROM zx_jurisdictions_gt b

1770: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1771: AND a.tax = 'CITY'
1772: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1773: AND a.precedence_level = (SELECT max(b.precedence_level)
1774: FROM zx_jurisdictions_gt b
1775: WHERE b.tax_regime_code = a.tax_regime_code
1776: AND substr(b.tax_jurisdiction_code, 4) BETWEEN
1777: '000000000' and '999999999'
1778: AND b.tax = 'CITY');

Line 1783: FROM zx_jurisdictions_gt a

1779: IF l_jur_count = 1 THEN
1780:
1781: SELECT substr(a.tax_jurisdiction_code, 4)
1782: INTO l_jur_code
1783: FROM zx_jurisdictions_gt a
1784: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1785: AND a.tax = 'CITY'
1786: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1787: AND a.precedence_level = (SELECT max(b.precedence_level)

Line 1788: FROM zx_jurisdictions_gt b

1784: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1785: AND a.tax = 'CITY'
1786: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1787: AND a.precedence_level = (SELECT max(b.precedence_level)
1788: FROM zx_jurisdictions_gt b
1789: WHERE b.tax_regime_code = a.tax_regime_code
1790: AND substr(b.tax_jurisdiction_code, 4)
1791: BETWEEN '000000000' and '999999999'
1792: AND b.tax = 'CITY');