DBA Data[Home] [Help]

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on JL_ZZ_AR_TX_CATEG_ALL

Line 5942: jl_zz_ar_tx_categ_all categs

5938: FROM
5939: ar_vat_tax_all_b codes,
5940: zx_party_tax_profile ptp,
5941: ar_system_parameters_all params,
5942: jl_zz_ar_tx_categ_all categs
5943: WHERE
5944: codes.tax_type <> 'TAX_GROUP'
5945:
5946: -- For LTE : YK:2/22/2005

Line 6943: jl_zz_ar_tx_categ_all categs

6939: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG tax_use_loc_exc_rate_flag
6940: FROM ZX_RATES_B rates,
6941: AR_VAT_TAX_ALL_B codes,
6942: AR_SYSTEM_PARAMETERS_ALL ar_sys_op,
6943: jl_zz_ar_tx_categ_all categs
6944: WHERE
6945: rates.record_type_code = 'MIGRATED'
6946: AND codes.vat_tax_id = rates.tax_rate_id
6947: AND decode(l_multi_org_flag,'N',l_org_id,codes.org_id) = decode(l_multi_org_flag,'N',l_org_id,ar_sys_op.org_id)

Line 8116: jl_zz_ar_tx_categ_all categs

8112: categs.description description,
8113: codes.global_attribute_category global_attribute_category
8114: from zx_rates_b rates,
8115: ar_vat_tax_all_b codes,
8116: jl_zz_ar_tx_categ_all categs
8117: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8118: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
8119: 'JL.BR.ARXSUVAT.AR_VAT_TAX',
8120: 'JL.CO.ARXSUVAT.AR_VAT_TAX')

Line 9511: jl_zz_ar_tx_categ_all categs

9507: FND_LANGUAGES L,
9508: ZX_TAXES_B B,
9509: zx_rates_b rates,
9510: ar_vat_tax_all_b codes,
9511: jl_zz_ar_tx_categ_all categs
9512: WHERE
9513: L.INSTALLED_FLAG in ('I', 'B')
9514: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9515: AND b.tax_regime_code = rates.tax_regime_code

Line 9560: jl_zz_ar_tx_categ_all categs

9556: FND_LANGUAGES L,
9557: ZX_TAXES_B B,
9558: zx_rates_b rates,
9559: ar_vat_tax_all_b codes,
9560: jl_zz_ar_tx_categ_all categs
9561: WHERE
9562: L.INSTALLED_FLAG in ('I', 'B')
9563: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9564: AND b.tax_regime_code = rates.tax_regime_code

Line 9609: jl_zz_ar_tx_categ_all categs

9605: FND_LANGUAGES L,
9606: ZX_TAXES_B B,
9607: zx_rates_b rates,
9608: ar_vat_tax_all_b codes,
9609: jl_zz_ar_tx_categ_all categs
9610: WHERE
9611: L.INSTALLED_FLAG in ('I', 'B')
9612: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9613: AND b.tax_regime_code = rates.tax_regime_code

Line 9723: jl_zz_ar_tx_categ_all categs

9719: categs.description description,
9720: codes.global_attribute_category global_attribute_category
9721: from zx_rates_b rates,
9722: ar_vat_tax_all_b codes,
9723: jl_zz_ar_tx_categ_all categs
9724: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
9725: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
9726: 'JL.BR.ARXSUVAT.AR_VAT_TAX',
9727: 'JL.CO.ARXSUVAT.AR_VAT_TAX')