DBA Data[Home] [Help]

APPS.ZX_MIGRATE_AR_TAX_DEF dependencies on FND_LANGUAGES

Line 7328: FND_LANGUAGES L,

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'

Line 8119: FND_LANGUAGES L,

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,

Line 8433: FND_LANGUAGES L,

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

Line 9106: ) codes,fnd_languages fln

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

Line 9325: FND_LANGUAGES L,

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'

Line 9519: FND_LANGUAGES L,

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

Line 9568: FND_LANGUAGES L,

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

Line 9617: FND_LANGUAGES L,

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

Line 9666: FND_LANGUAGES L,

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'

Line 9726: FND_LANGUAGES L,

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,

Line 9838: FND_LANGUAGES L,

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'

Line 9919: fnd_languages l

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