APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_RULES_B_TMP

Line 1639: INTO ZX_RULES_B_TMP

1635: and rates.record_type_code = 'MIGRATED'
1636: )
1637: )
1638: THEN
1639: INTO ZX_RULES_B_TMP
1640: (
1641: TAX_RULE_ID ,
1642: TAX_RULE_CODE ,
1643: TAX ,

Line 1708: from ZX_RULES_B_TMP rule

1704: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1705: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1706: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1707: AND NOT EXISTS ( select 1
1708: from ZX_RULES_B_TMP rule
1709: where
1710: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1711: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1712: and rule.TAX = taxes.TAX

Line 1722: INSERT ALL INTO ZX_RULES_B_TMP

1718: ) ;
1719: */
1720: --Bug : 5061471
1721: -- Create Direct Rate Rule for distinct tax_regime, tax and content_owner_id combination for both AP and AR
1722: INSERT ALL INTO ZX_RULES_B_TMP
1723: (
1724: TAX_RULE_ID ,
1725: TAX_RULE_CODE ,
1726: TAX ,

Line 1804: from ZX_RULES_B_TMP rule

1800: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1801: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1802: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1803: AND NOT EXISTS ( select 1
1804: from ZX_RULES_B_TMP rule
1805: where
1806: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1807: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1808: and rule.TAX = taxes.TAX

Line 1845: from ZX_RULES_B_TMP rule

1841: and rates.tax_regime_code = taxes.TAX_REGIME_CODE
1842: AND rates.content_owner_id = taxes.content_owner_id
1843: and rates.record_type_code = 'MIGRATED' )
1844: AND NOT EXISTS ( select 1
1845: from ZX_RULES_B_TMP rule
1846: where
1847: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1848: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1849: and rule.TAX = taxes.TAX

Line 1864: INTO ZX_RULES_B_TMP

1860: --Create Applicability Rules For Location Based Taxes , Refer Bug 4910386
1861: --Refer Bug 4935978 for further modificatiions
1862:
1863: INSERT ALL
1864: INTO ZX_RULES_B_TMP
1865: (
1866: TAX_RULE_ID ,
1867: TAX_RULE_CODE ,
1868: TAX ,

Line 2032: INSERT ALL INTO ZX_RULES_B_TMP

2028: -- Create Rate Determination Rule for location based taxes for OKL migration
2029: -- even though there can be VAT taxes with leasing flag as 'Y', but for these taxes
2030: -- no multiple rate will be defined, hence no need to create the rate det rules.
2031:
2032: INSERT ALL INTO ZX_RULES_B_TMP
2033: (
2034: TAX_RULE_ID ,
2035: TAX_RULE_CODE ,
2036: TAX ,

Line 2122: from ZX_RULES_B_TMP rule

2118: taxgrp.trx_business_category_code ||
2119: taxgrp.party_fisc_classification IS NOT NULL
2120: )
2121: AND NOT EXISTS ( select 1
2122: from ZX_RULES_B_TMP rule
2123: where
2124: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
2125: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
2126: and rule.TAX = taxes.TAX