APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_RULES_B_TMP

Line 1483: INTO ZX_RULES_B_TMP

1479: and rates.record_type_code = 'MIGRATED'
1480: )
1481: )
1482: THEN
1483: INTO ZX_RULES_B_TMP
1484: (
1485: TAX_RULE_ID ,
1486: TAX_RULE_CODE ,
1487: TAX ,

Line 1552: from ZX_RULES_B_TMP rule

1548: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1549: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1550: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1551: AND NOT EXISTS ( select 1
1552: from ZX_RULES_B_TMP rule
1553: where
1554: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1555: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1556: and rule.TAX = taxes.TAX

Line 1566: INSERT ALL INTO ZX_RULES_B_TMP

1562: ) ;
1563: */
1564: --Bug : 5061471
1565: -- Create Direct Rate Rule for distinct tax_regime, tax and content_owner_id combination for both AP and AR
1566: INSERT ALL INTO ZX_RULES_B_TMP
1567: (
1568: TAX_RULE_ID ,
1569: TAX_RULE_CODE ,
1570: TAX ,

Line 1648: from ZX_RULES_B_TMP rule

1644: AND taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1645: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1646: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1647: AND NOT EXISTS ( select 1
1648: from ZX_RULES_B_TMP rule
1649: where
1650: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1651: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1652: and rule.TAX = taxes.TAX

Line 1686: from ZX_RULES_B_TMP rule

1682: and rates.tax_regime_code = taxes.TAX_REGIME_CODE
1683: AND rates.content_owner_id = taxes.content_owner_id
1684: and rates.record_type_code = 'MIGRATED' )
1685: AND NOT EXISTS ( select 1
1686: from ZX_RULES_B_TMP rule
1687: where
1688: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1689: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1690: and rule.TAX = taxes.TAX

Line 1703: INTO ZX_RULES_B_TMP

1699: --Create Applicability Rules For Location Based Taxes , Refer Bug 4910386
1700: --Refer Bug 4935978 for further modificatiions
1701:
1702: INSERT ALL
1703: INTO ZX_RULES_B_TMP
1704: (
1705: TAX_RULE_ID ,
1706: TAX_RULE_CODE ,
1707: TAX ,

Line 1866: INSERT ALL INTO ZX_RULES_B_TMP

1862: -- Create Rate Determination Rule for location based taxes for OKL migration
1863: -- even though there can be VAT taxes with leasing flag as 'Y', but for these taxes
1864: -- no multiple rate will be defined, hence no need to create the rate det rules.
1865:
1866: INSERT ALL INTO ZX_RULES_B_TMP
1867: (
1868: TAX_RULE_ID ,
1869: TAX_RULE_CODE ,
1870: TAX ,

Line 1956: from ZX_RULES_B_TMP rule

1952: taxgrp.trx_business_category_code ||
1953: taxgrp.party_fisc_classification IS NOT NULL
1954: )
1955: AND NOT EXISTS ( select 1
1956: from ZX_RULES_B_TMP rule
1957: where
1958: rule.CONTENT_OWNER_ID = taxes.CONTENT_OWNER_ID
1959: and rule.TAX_REGIME_CODE = taxes.TAX_REGIME_CODE
1960: and rule.TAX = taxes.TAX