APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_ID_TCC_MAPPING_ALL

Line 1790: ZX_ID_TCC_MAPPING_ALL idmap

1786: FROM
1787: ZX_TAXES_B taxes ,
1788: ZX_RATES_B rates,
1789: AR_TAX_GROUP_CODES_ALL taxgrp,
1790: ZX_ID_TCC_MAPPING_ALL idmap
1791: WHERE taxgrp.ENABLED_FLAG = 'Y'
1792: AND taxgrp.tax_code_id = idmap.tax_rate_code_id
1793: AND taxgrp.tax_group_type =idmap.source
1794: and taxgrp.org_id = idmap.org_id

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'