APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on AR_SYSTEM_PARAMETERS_ALL

Line 842: FROM ar_system_parameters_all sys

838: AR_VAT_TAX_ALL_B ar_vat --Bug 5061471
839: WHERE
840: ar_vat.tax_type IN ( 'TAX_GROUP','LOCATION')
841: OR EXISTS ( SELECT 1
842: FROM ar_system_parameters_all sys
843: WHERE ar_vat.set_of_books_id = sys.set_of_books_id
844: AND ar_vat.org_id = sys.org_id
845: AND sys.tax_method = 'SALES_TAX')
846: --Added following AND condition for Sync process

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

1830: taxes.TAX_TYPE_CODE NOT IN ('AWT','OFFSET')
1831: AND taxes.RECORD_TYPE_CODE = 'MIGRATED'
1832: AND taxes.tax_type_code <> 'LOCATION' --Bug Fix 4626074
1833: and exists ( select 1
1834: from zx_rates_b rates,zx_id_tcc_mapping_all idmap,ar_system_parameters_all sys
1835: where idmap.ledger_id = sys.set_of_books_id
1836: AND idmap.org_id = sys.org_id
1837: AND idmap.source = 'AR'
1838: AND sys.tax_method = 'SALES_TAX'

Line 1933: ar_system_parameters_all sys

1929: FROM
1930: ZX_TAXES_B taxes,
1931: -- AR_VAT_TAX_ALL_B vat,
1932: zx_party_tax_profile ptp,
1933: ar_system_parameters_all sys
1934: WHERE
1935: taxes.RECORD_TYPE_CODE = 'MIGRATED'
1936: AND taxes.tax_type_code = 'LOCATION'
1937: AND taxes.live_for_applicability_flag = 'Y'

Line 1979: ar_system_parameters_all sys,

1975: FROM
1976: ZX_TAXES_B taxes,
1977: AR_VAT_TAX_ALL_B vat,
1978: zx_party_tax_profile ptp,
1979: ar_system_parameters_all sys,
1980: AR_TAX_GROUP_CODES_ALL taxgrp
1981:
1982: WHERE
1983: taxes.RECORD_TYPE_CODE = 'MIGRATED'

Line 2144: ar_system_parameters_all sys,

2140: srvtype.service_type_code l_service_type_code
2141: FROM
2142: ZX_TAXES_B taxes,
2143: zx_party_tax_profile ptp,
2144: ar_system_parameters_all sys,
2145: (SELECT 'DET_APPLICABLE_TAXES' service_type_code
2146: FROM DUAL
2147: UNION
2148: SELECT 'DET_TAX_RATE' service_type_code

Line 2858: ar_system_parameters_all sys

2854: ZX_RATES_B rates,
2855: ZX_RULES_B rules,
2856: ZX_CONDITION_GROUPS_B cond_groups,
2857: AR_VAT_TAX_ALL_B codes,
2858: ar_system_parameters_all sys
2859: WHERE
2860: rates.RECORD_TYPE_CODE = 'MIGRATED'
2861: AND codes.vat_tax_id = rates.tax_rate_id
2862: AND codes.tax_type NOT IN('AWT','OFFSET','TAX_GROUP')

Line 3048: ar_system_parameters_all sys

3044: ZX_CONDITION_GROUPS_B CG,
3045: ZX_PARTY_TAX_PROFILE PTP,
3046: AR_VAT_TAX_ALL_B VAT ,
3047: ZX_RULES_B RULES,
3048: ar_system_parameters_all sys
3049: WHERE
3050: taxes.RECORD_TYPE_CODE = 'MIGRATED'
3051: AND taxes.tax_type_code = 'LOCATION'
3052: AND taxes.live_for_applicability_flag = 'Y'

Line 3101: ar_system_parameters_all sys

3097: ZX_TAXES_B TAXES,
3098: ZX_RULES_B rules,
3099: ZX_CONDITION_GROUPS_B cond_groups,
3100: ZX_PARTY_TAX_PROFILE PTP,
3101: ar_system_parameters_all sys
3102: WHERE
3103: gvat.vat_tax_id = gc.tax_group_id
3104: AND gc.tax_group_type = 'AR'
3105: AND gvat.tax_type = 'TAX_GROUP'

Line 3300: ar_system_parameters_all sys,

3296: AR_TAX_GROUP_CODES_ALL taxgrp,
3297: ZX_TAXES_B TAXES,
3298: ZX_RULES_B rules,
3299: ZX_CONDITION_GROUPS_B cg,
3300: ar_system_parameters_all sys,
3301: zx_party_tax_profile ptp
3302:
3303: WHERE taxgrp.tax_group_type = 'AR'
3304: AND taxgrp.product_fisc_classification ||

Line 3517: ar_system_parameters_all sys,

3513: AR_VAT_TAX_ALL_B vat,
3514: ZX_TAXES_B TAXES,
3515: ZX_RULES_B rules,
3516: ZX_CONDITION_GROUPS_B cg,
3517: ar_system_parameters_all sys,
3518: zx_party_tax_profile ptp,
3519: ZX_RATES_B oklrates,
3520: ZX_RATES_B rates
3521: