[Home] [Help]
1175: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location Type: ',l_location_type);
1176: FND_LOG.STRING(G_LEVEL_STATEMENT,'Location ID: ',to_char(p_bill_to_location_id));
1177: END IF;
1178:
1179: delete from zx_jurisdictions_gt;
1180:
1181: IF p_bill_to_location_id IS NOT NULL THEN
1182: ZX_TCM_GEO_JUR_PKG.get_tax_jurisdictions (
1183: p_location_id => p_bill_to_location_id,
1911: ELSE
1912: BEGIN
1913: SELECT count(*)
1914: INTO l_jur_count
1915: FROM zx_jurisdictions_gt a
1916: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1917: AND a.tax = 'CITY'
1918: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1919: AND a.precedence_level = (SELECT min(b.precedence_level)
1916: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1917: AND a.tax = 'CITY'
1918: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1919: AND a.precedence_level = (SELECT min(b.precedence_level)
1920: FROM zx_jurisdictions_gt b
1921: WHERE b.tax_regime_code = a.tax_regime_code
1922: AND substr(b.tax_jurisdiction_code, 4) BETWEEN
1923: '000000000' and '999999999'
1924: AND b.tax = 'CITY');
1925: IF l_jur_count = 1 THEN
1926:
1927: SELECT substr(a.tax_jurisdiction_code, 4)
1928: INTO l_jur_code
1929: FROM zx_jurisdictions_gt a
1930: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1931: AND a.tax = 'CITY'
1932: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1933: AND a.precedence_level = (SELECT min(b.precedence_level)
1930: WHERE a.tax_regime_code = tax_regime_code_tab(i)
1931: AND a.tax = 'CITY'
1932: AND substr(a.tax_jurisdiction_code, 4) BETWEEN '000000000' and '999999999'
1933: AND a.precedence_level = (SELECT min(b.precedence_level)
1934: FROM zx_jurisdictions_gt b
1935: WHERE b.tax_regime_code = a.tax_regime_code
1936: AND substr(b.tax_jurisdiction_code, 4)
1937: BETWEEN '000000000' and '999999999'
1938: AND b.tax = 'CITY');