DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_TAXES_B

Line 1546: ZX_TAXES_B taxes

1542: taxes.EFFECTIVE_FROM EFFECTIVE_FROM ,
1543: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
1544: taxes.CONTENT_OWNER_ID
1545: FROM
1546: ZX_TAXES_B taxes
1547: WHERE
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

Line 1631: ZX_TAXES_B taxes ,

1627: taxgrp.END_DATE EFFECTIVE_TO ,
1628: taxes.CONTENT_OWNER_ID,
1629: (taxgrp.tax_group_id * 2) + taxgrp.DISPLAY_ORDER PRIORITY
1630: FROM
1631: ZX_TAXES_B taxes ,
1632: ZX_RATES_B rates,
1633: AR_TAX_GROUP_CODES_ALL taxgrp,
1634: ZX_ID_TCC_MAPPING_ALL idmap
1635: WHERE

Line 1669: ZX_TAXES_B taxes

1665: taxes.CONTENT_OWNER_ID ,
1666: 1 PRIORITY
1667:
1668: FROM
1669: ZX_TAXES_B taxes
1670: WHERE
1671: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1672: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1673: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074

Line 1769: ZX_TAXES_B taxes,

1765: -- nvl(vat.enabled_flag,'Y') ENABLED_FLAG
1766: 'Y' ENABLED_FLAG, -- Bug 5209434
1767: 1 PRIORITY
1768: FROM
1769: ZX_TAXES_B taxes,
1770: -- AR_VAT_TAX_ALL_B vat,
1771: zx_party_tax_profile ptp,
1772: ar_system_parameters_all sys
1773: WHERE

Line 1815: ZX_TAXES_B taxes,

1811: -- nvl(vat.enabled_flag,'Y') ENABLED_FLAG
1812: 'Y' ENABLED_FLAG, -- Bug 5209434
1813: (taxgrp.tax_group_id * 2) + taxgrp.DISPLAY_ORDER PRIORITY
1814: FROM
1815: ZX_TAXES_B taxes,
1816: AR_VAT_TAX_ALL_B vat,
1817: zx_party_tax_profile ptp,
1818: ar_system_parameters_all sys,
1819: AR_TAX_GROUP_CODES_ALL taxgrp

Line 1930: ZX_TAXES_B taxes,

1926: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
1927: taxes.CONTENT_OWNER_ID ,
1928: srvtype.service_type_code l_service_type_code
1929: FROM
1930: ZX_TAXES_B taxes,
1931: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1932: FROM DUAL
1933: UNION
1934: SELECT 'DET_TAX_RATE' service_type_code

Line 1976: ZX_TAXES_B taxes,

1972: taxes.EFFECTIVE_TO EFFECTIVE_TO ,
1973: taxes.CONTENT_OWNER_ID,
1974: srvtype.service_type_code l_service_type_code
1975: FROM
1976: ZX_TAXES_B taxes,
1977: zx_party_tax_profile ptp,
1978: ar_system_parameters_all sys,
1979: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
1980: FROM DUAL

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

Line 2140: INSERT INTO ZX_TAXES_B (

2136:
2137: -- bug fix: 5548613: copy the location based taxes
2138: -- which has an applicability rule defined.
2139:
2140: INSERT INTO ZX_TAXES_B (
2141: TAX
2142: ,EFFECTIVE_FROM
2143: ,EFFECTIVE_TO
2144: ,TAX_REGIME_CODE

Line 2353: ,ZX_TAXES_B_S.NEXTVAL

2349: ,tax.ALLOW_DUP_REGN_NUM_FLAG
2350: ,tax.DEF_SECONDARY_REC_RATE_CODE
2351: ,tax.SPECIAL_INCLUSIVE_TAX_FLAG
2352: ,tax.PROGRAM_LOGIN_ID
2353: ,ZX_TAXES_B_S.NEXTVAL
2354: ,rule.CONTENT_OWNER_ID
2355: ,tax.REP_TAX_AUTHORITY_ID
2356: ,tax.COLL_TAX_AUTHORITY_ID
2357: ,tax.THRSHLD_CHK_TMPLT_CODE

Line 2367: FROM ZX_TAXES_B tax, zx_rules_b rule

2363: ,tax.TAX_EXMPT_CR_METHOD_CODE
2364: ,tax.TAX_EXMPT_SOURCE_TAX
2365: ,tax.APPLICABLE_BY_DEFAULT_FLAG
2366: ,tax.LEGAL_REPORTING_STATUS_DEF_VAL
2367: FROM ZX_TAXES_B tax, zx_rules_b rule
2368: WHERE tax.tax_type_code ='LOCATION'
2369: AND tax.RECORD_TYPE_CODE = 'MIGRATED'
2370: AND tax.live_for_applicability_flag = 'Y' -- add to filter location taxes defined in 11i
2371: AND tax.content_owner_id = -99

Line 2381: FROM zx_taxes_b tax2

2377: AND rule.tax_rule_code = tax.tax
2378: AND rule.priority = 1
2379: AND NOT EXISTS (
2380: SELECT 1
2381: FROM zx_taxes_b tax2
2382: WHERE tax2.tax = tax.tax
2383: AND tax2.tax_regime_code = tax.tax_regime_code
2384: AND tax2.content_owner_id = tax.content_owner_id);
2385:

Line 2868: FROM ZX_TAXES_B TAXES,

2864: rules.tax_rule_id TAX_RULE_ID ,
2865: NULL CONDITION_SET_ID ,
2866: NULL EXCEPTION_SET_ID ,
2867: decode(vat.leasing_flag,'Y',vat.tax_code,'STANDARD') RATE_RESULT
2868: FROM ZX_TAXES_B TAXES,
2869: ZX_CONDITION_GROUPS_B CG,
2870: ZX_PARTY_TAX_PROFILE PTP,
2871: AR_VAT_TAX_ALL_B VAT ,
2872: ZX_RULES_B RULES,

Line 2921: ZX_TAXES_B TAXES,

2917: AR_TAX_GROUP_CODES_ALL gc,
2918: AR_VAT_TAX_ALL_B vat,
2919: AR_TAX_CONDITIONS_ALL cond,
2920: AR_TAX_CONDITIONS_ALL excp,
2921: ZX_TAXES_B TAXES,
2922: ZX_RULES_B rules,
2923: ZX_CONDITION_GROUPS_B cond_groups,
2924: ZX_PARTY_TAX_PROFILE PTP,
2925: ar_system_parameters_all sys

Line 3058: ZX_TAXES_B TAXES,

3054: taxgrp.TAX_EXCEPTION_ID EXCEPTION_SET_ID
3055:
3056: FROM AR_VAT_TAX_ALL_B gvat,
3057: AR_TAX_GROUP_CODES_ALL taxgrp,
3058: ZX_TAXES_B TAXES,
3059: ZX_RULES_B rules,
3060: ZX_CONDITION_GROUPS_B cg
3061: WHERE gvat.vat_tax_id = taxgrp.tax_group_id
3062: AND taxgrp.tax_group_type = 'AR'

Line 3114: ZX_TAXES_B TAXES,

3110: taxgrp.tax_exception_id EXCEPTION_SET_ID
3111:
3112: FROM AR_VAT_TAX_ALL_B gvat,
3113: AR_TAX_GROUP_CODES_ALL taxgrp,
3114: ZX_TAXES_B TAXES,
3115: ZX_RULES_B rules,
3116: ZX_CONDITION_GROUPS_B cg,
3117: ar_system_parameters_all sys,
3118: zx_party_tax_profile ptp

Line 3275: -- ZX_TAXES_B TAXES,

3271:
3272: FROM AR_VAT_TAX_ALL_B gvat,
3273: AR_TAX_GROUP_CODES_ALL taxgrp,
3274: AR_VAT_TAX_ALL_B vat,
3275: -- ZX_TAXES_B TAXES,
3276: ZX_RULES_B rules,
3277: ZX_CONDITION_GROUPS_B cg,
3278: ZX_RATES_B rates
3279: WHERE gvat.vat_tax_id = taxgrp.tax_group_id

Line 3331: ZX_TAXES_B TAXES,

3327:
3328: FROM AR_VAT_TAX_ALL_B gvat,
3329: AR_TAX_GROUP_CODES_ALL taxgrp,
3330: AR_VAT_TAX_ALL_B vat,
3331: ZX_TAXES_B TAXES,
3332: ZX_RULES_B rules,
3333: ZX_CONDITION_GROUPS_B cg,
3334: ar_system_parameters_all sys,
3335: zx_party_tax_profile ptp,