DBA Data[Home] [Help]

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on JL_ZZ_AR_TX_CATEG_ALL

Line 5954: jl_zz_ar_tx_categ_all categs

5950: FROM
5951: ar_vat_tax_all_b codes,
5952: zx_party_tax_profile ptp,
5953: ar_system_parameters_all params,
5954: jl_zz_ar_tx_categ_all categs
5955: WHERE
5956: codes.tax_type <> 'TAX_GROUP'
5957:
5958: -- For LTE : YK:2/22/2005

Line 6955: jl_zz_ar_tx_categ_all categs

6951: AR_SYS_OP.TAX_USE_LOC_EXC_RATE_FLAG tax_use_loc_exc_rate_flag
6952: FROM ZX_RATES_B rates,
6953: AR_VAT_TAX_ALL_B codes,
6954: AR_SYSTEM_PARAMETERS_ALL ar_sys_op,
6955: jl_zz_ar_tx_categ_all categs
6956: WHERE
6957: rates.record_type_code = 'MIGRATED'
6958: AND codes.vat_tax_id = rates.tax_rate_id
6959: 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 8128: jl_zz_ar_tx_categ_all categs

8124: categs.description description,
8125: codes.global_attribute_category global_attribute_category
8126: from zx_rates_b rates,
8127: ar_vat_tax_all_b codes,
8128: jl_zz_ar_tx_categ_all categs
8129: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
8130: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
8131: 'JL.BR.ARXSUVAT.AR_VAT_TAX',
8132: 'JL.CO.ARXSUVAT.AR_VAT_TAX')

Line 9523: jl_zz_ar_tx_categ_all categs

9519: FND_LANGUAGES L,
9520: ZX_TAXES_B B,
9521: zx_rates_b rates,
9522: ar_vat_tax_all_b codes,
9523: jl_zz_ar_tx_categ_all categs
9524: WHERE
9525: L.INSTALLED_FLAG in ('I', 'B')
9526: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9527: AND b.tax_regime_code = rates.tax_regime_code

Line 9572: jl_zz_ar_tx_categ_all categs

9568: FND_LANGUAGES L,
9569: ZX_TAXES_B B,
9570: zx_rates_b rates,
9571: ar_vat_tax_all_b codes,
9572: jl_zz_ar_tx_categ_all categs
9573: WHERE
9574: L.INSTALLED_FLAG in ('I', 'B')
9575: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9576: AND b.tax_regime_code = rates.tax_regime_code

Line 9621: jl_zz_ar_tx_categ_all categs

9617: FND_LANGUAGES L,
9618: ZX_TAXES_B B,
9619: zx_rates_b rates,
9620: ar_vat_tax_all_b codes,
9621: jl_zz_ar_tx_categ_all categs
9622: WHERE
9623: L.INSTALLED_FLAG in ('I', 'B')
9624: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9625: AND b.tax_regime_code = rates.tax_regime_code

Line 9735: jl_zz_ar_tx_categ_all categs

9731: categs.description description,
9732: codes.global_attribute_category global_attribute_category
9733: from zx_rates_b rates,
9734: ar_vat_tax_all_b codes,
9735: jl_zz_ar_tx_categ_all categs
9736: where codes.vat_tax_id = nvl(rates.source_id, rates.tax_rate_id)
9737: and codes.global_attribute_category in ('JL.AR.ARXSUVAT.AR_VAT_TAX',
9738: 'JL.BR.ARXSUVAT.AR_VAT_TAX',
9739: 'JL.CO.ARXSUVAT.AR_VAT_TAX')