APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_TAXES_B_TMP

Line 2069: update zx_taxes_b_tmp tax

2065:
2066: --Bug : 5090631 : Added to update the DIRECT_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2067: -- direct rate rules have been created.
2068:
2069: update zx_taxes_b_tmp tax
2070: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2071: where exists
2072: ( select 1
2073: from zx_rules_b rule

Line 2084: update zx_taxes_b_tmp tax

2080: and rule.tax_rule_code = tax.tax );
2081: -- and rule.priority = 1);
2082:
2083: -- bug fix: 5548613 update the DIRECT_RATE_RULE_FLAG to 'Y' for location based taxes which have the direct rate rule migrated
2084: update zx_taxes_b_tmp tax
2085: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2086: where tax.tax_type_code = 'LOCATION'
2087: and tax.RECORD_TYPE_CODE = 'MIGRATED'
2088: and tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i

Line 2105: update zx_taxes_b_tmp tax

2101:
2102: -- Added to update the TAX_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2103: -- direct rate rules have been created.
2104:
2105: update zx_taxes_b_tmp tax
2106: set tax.TAX_RATE_RULE_FLAG = 'Y'
2107: where exists
2108: ( select 1
2109: from zx_rules_b rule

Line 2123: update zx_taxes_b_tmp tax

2119: --
2120: -- Added to update the APPLICABILITY_RULE to 'Y' for all tax,regime,contentOwners for which
2121: -- applicability rules have been created.
2122:
2123: update zx_taxes_b_tmp tax
2124: set tax.APPLICABILITY_RULE_FLAG = 'Y'
2125: where exists
2126: ( select 1
2127: from zx_rules_b rule