7324: fnd_global.conc_login_id,
7325: L.LANGUAGE_CODE,
7326: userenv('LANG')
7327: FROM
7328: FND_LANGUAGES L,
7329: ZX_STATUS_B B -- cartesian join
7330: WHERE
7331: L.INSTALLED_FLAG in ('I', 'B')
7332: AND RECORD_TYPE_CODE = 'MIGRATED'
8115: fnd_global.user_id ,
8116: fnd_global.conc_login_id ,
8117: B.TAX_ID
8118: FROM
8119: FND_LANGUAGES L,
8120: ZX_TAXES_B B,
8121: (select rates.tax_regime_code tax_regime_code,
8122: rates.tax tax,
8123: rates.content_owner_id content_owner_id,
8429: fnd_global.user_id ,
8430: fnd_global.conc_login_id ,
8431: B.TAX_REGIME_ID
8432: FROM
8433: FND_LANGUAGES L,
8434: ZX_REGIMES_B B,
8435: (select rates.tax_regime_code tax_regime_code,
8436: lkups.meaning meaning,
8437: codes.global_attribute_category global_attribute_category
9102: -- codes.tax_type <> 'LOCATION'
9103: codes.vat_tax_id = NVL(p_tax_id, codes.vat_tax_id)
9104: AND codes.tax_code = cursor_rec.tax_code
9105: AND ROWNUM =1
9106: ) codes,fnd_languages fln
9107: where fln.installed_flag in ('I','B')
9108: AND NOT EXISTS
9109: (select 1
9110: from fnd_lookup_values flv
9321: fnd_global.conc_login_id,
9322: L.LANGUAGE_CODE,
9323: userenv('LANG')
9324: FROM
9325: FND_LANGUAGES L,
9326: ZX_REGIMES_B B -- cartesian join
9327: WHERE
9328: L.INSTALLED_FLAG in ('I', 'B')
9329: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9515: fnd_global.user_id ,
9516: fnd_global.conc_login_id ,
9517: B.TAX_ID
9518: FROM
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
9564: fnd_global.user_id ,
9565: fnd_global.conc_login_id ,
9566: B.TAX_ID
9567: FROM
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
9613: fnd_global.user_id ,
9614: fnd_global.conc_login_id ,
9615: B.TAX_ID
9616: FROM
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
9662: fnd_global.conc_login_id,
9663: L.LANGUAGE_CODE,
9664: userenv('LANG')
9665: FROM
9666: FND_LANGUAGES L,
9667: ZX_TAXES_B B -- cartesian join
9668: WHERE
9669: L.INSTALLED_FLAG in ('I', 'B')
9670: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9722: fnd_global.user_id ,
9723: fnd_global.conc_login_id ,
9724: B.TAX_ID
9725: FROM
9726: FND_LANGUAGES L,
9727: ZX_TAXES_B B,
9728: (select rates.tax_regime_code tax_regime_code,
9729: rates.tax tax,
9730: rates.content_owner_id content_owner_id,
9834: fnd_global.conc_login_id,
9835: L.LANGUAGE_CODE,
9836: userenv('LANG')
9837: FROM
9838: FND_LANGUAGES L,
9839: ZX_STATUS_B B -- cartesian join
9840: WHERE
9841: L.INSTALLED_FLAG in ('I', 'B')
9842: AND B.RECORD_TYPE_CODE = 'MIGRATED'
9915: l.language_code ,
9916: userenv('LANG') ,
9917: Initcap(zrb.tax_rate_code)
9918: FROM zx_rates_b zrb,
9919: fnd_languages l
9920: WHERE L.INSTALLED_FLAG in ('I', 'B')
9921: AND zrb.RECORD_TYPE_CODE = 'MIGRATED'
9922: AND zrb.tax_jurisdiction_code IS NULL
9923: AND NOT EXISTS (SELECT 1