APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 829: FROM ar_system_parameters_all sys

825: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471
826: WHERE
827: ar_vat.tax_type IN ( 'TAX_GROUP','LOCATION')
828: OR EXISTS ( SELECT 1
829: FROM ar_system_parameters_all sys
830: WHERE ar_vat.set_of_books_id = sys.set_of_books_id
831: AND ar_vat.org_id = sys.org_id
832: AND sys.tax_method = 'SALES_TAX')
833: --Added following AND condition for Sync process

Line 1675: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys

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
1674: and exists ( select 1
1675: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys
1676: where idmap.ledger_id = sys.set_of_books_id
1677: AND idmap.org_id = sys.org_id
1678: AND idmap.source = 'AR'
1679: AND sys.tax_method = 'SALES_TAX'

Line 1772: ar_system_parameters_all sys

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
1774: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1775: AND taxes.tax_type_code = 'LOCATION'
1776: AND taxes.live_for_applicability_flag = 'Y'

Line 1818: ar_system_parameters_all sys,

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
1820:
1821: WHERE
1822: taxes.RECORD_TYPE_CODE = 'MIGRATED'

Line 1978: ar_system_parameters_all sys,

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
1981: UNION
1982: SELECT 'DET_TAX_RATE' service_type_code

Line 2691: ar_system_parameters_all sys

2687: ZX_RATES_B rates,
2688: ZX_RULES_B rules,
2689: ZX_CONDITION_GROUPS_B cond_groups,
2690: AR_VAT_TAX_ALL_B codes,
2691: ar_system_parameters_all sys
2692: WHERE
2693: rates.RECORD_TYPE_CODE = 'MIGRATED'
2694: AND codes.vat_tax_id = rates.tax_rate_id
2695: AND codes.tax_type NOT IN('AWT','OFFSET','TAX_GROUP')

Line 2873: ar_system_parameters_all sys

2869: ZX_CONDITION_GROUPS_B CG,
2870: ZX_PARTY_TAX_PROFILE PTP,
2871: AR_VAT_TAX_ALL_B VAT ,
2872: ZX_RULES_B RULES,
2873: ar_system_parameters_all sys
2874: WHERE
2875: taxes.RECORD_TYPE_CODE = 'MIGRATED'
2876: AND taxes.tax_type_code = 'LOCATION'
2877: AND taxes.live_for_applicability_flag = 'Y'

Line 2925: ar_system_parameters_all sys

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
2926: WHERE
2927: gvat.vat_tax_id = gc.tax_group_id
2928: AND gc.tax_group_type = 'AR'
2929: AND gvat.tax_type = 'TAX_GROUP'

Line 3117: ar_system_parameters_all sys,

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
3119:
3120: WHERE taxgrp.tax_group_type = 'AR'
3121: AND taxgrp.product_fisc_classification ||

Line 3334: ar_system_parameters_all sys,

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,
3336: ZX_RATES_B oklrates,
3337: ZX_RATES_B rates
3338: