APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_ID_TCC_MAPPING_ALL

Line 1634: ZX_ID_TCC_MAPPING_ALL idmap

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
1636: taxgrp.tax_code_id = idmap.tax_rate_code_id
1637: AND taxgrp.tax_group_type =idmap.source
1638: and taxgrp.org_id = idmap.org_id

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'