APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_TAXES_B_TMP

Line 2235: update zx_taxes_b_tmp tax

2231:
2232: --Bug : 5090631 : Added to update the DIRECT_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2233: -- direct rate rules have been created.
2234:
2235: update zx_taxes_b_tmp tax
2236: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2237: where exists
2238: ( select 1
2239: from zx_rules_b rule

Line 2250: update zx_taxes_b_tmp tax

2246: and rule.tax_rule_code = tax.tax );
2247: -- and rule.priority = 1);
2248:
2249: -- bug fix: 5548613 update the DIRECT_RATE_RULE_FLAG to 'Y' for location based taxes which have the direct rate rule migrated
2250: update zx_taxes_b_tmp tax
2251: set tax.DIRECT_RATE_RULE_FLAG = 'Y'
2252: where tax.tax_type_code = 'LOCATION'
2253: and tax.RECORD_TYPE_CODE = 'MIGRATED'
2254: and tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i

Line 2271: update zx_taxes_b_tmp tax

2267:
2268: -- Added to update the TAX_RATE_RULE_FLAG to 'Y' for all tax,regime,contentOwners for which
2269: -- direct rate rules have been created.
2270:
2271: update zx_taxes_b_tmp tax
2272: set tax.TAX_RATE_RULE_FLAG = 'Y'
2273: where exists
2274: ( select 1
2275: from zx_rules_b rule

Line 2289: update zx_taxes_b_tmp tax

2285: --
2286: -- Added to update the APPLICABILITY_RULE to 'Y' for all tax,regime,contentOwners for which
2287: -- applicability rules have been created.
2288:
2289: update zx_taxes_b_tmp tax
2290: set tax.APPLICABILITY_RULE_FLAG = 'Y'
2291: where exists
2292: ( select 1
2293: from zx_rules_b rule