APPS.ZX_MIGRATE_TAX_DEF dependencies on FND_LOOKUP_VALUES

Line 255: INSERT INTO FND_LOOKUP_VALUES

251: FROM ap_tax_codes_all;
252:
253: IF l_cnt <> 0 THEN*/
254: BEGIN
255: INSERT INTO FND_LOOKUP_VALUES
256: (
257: LOOKUP_TYPE ,
258: LANGUAGE ,
259: LOOKUP_CODE ,

Line 327: FROM FND_LOOKUP_VALUES ap_lookups

323: fnd_global.user_id ,
324: SYSDATE ,
325: fnd_global.user_id ,
326: fnd_global.conc_login_id
327: FROM FND_LOOKUP_VALUES ap_lookups
328: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
329: AND NOT EXISTS
330: (select 1 from FND_LOOKUP_VALUES
331: where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'

Line 330: (select 1 from FND_LOOKUP_VALUES

326: fnd_global.conc_login_id
327: FROM FND_LOOKUP_VALUES ap_lookups
328: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
329: AND NOT EXISTS
330: (select 1 from FND_LOOKUP_VALUES
331: where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
332: and lookup_code = ap_lookups.lookup_code);
333: EXCEPTION
334: WHEN OTHERS THEN

Line 352: INSERT INTO FND_LOOKUP_VALUES

348: FROM ap_tax_codes_all;
349:
350: IF l_cnt <> 0 THEN*/
351:
352: INSERT INTO FND_LOOKUP_VALUES
353: (
354: LOOKUP_TYPE ,
355: LANGUAGE ,
356: LOOKUP_CODE ,

Line 424: FROM FND_LOOKUP_VALUES ap_lookups

420: fnd_global.user_id ,
421: SYSDATE ,
422: fnd_global.user_id ,
423: fnd_global.conc_login_id
424: FROM FND_LOOKUP_VALUES ap_lookups
425: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
426: -- Changed the re-runnability check
427: AND NOT EXISTS
428: (select 1 from FND_LOOKUP_VALUES

Line 428: (select 1 from FND_LOOKUP_VALUES

424: FROM FND_LOOKUP_VALUES ap_lookups
425: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
426: -- Changed the re-runnability check
427: AND NOT EXISTS
428: (select 1 from FND_LOOKUP_VALUES
429: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
430: and lookup_code = ap_lookups.lookup_code)
431: and NOT EXISTS
432: (select 1 from FND_LOOKUP_VALUES

Line 432: (select 1 from FND_LOOKUP_VALUES

428: (select 1 from FND_LOOKUP_VALUES
429: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
430: and lookup_code = ap_lookups.lookup_code)
431: and NOT EXISTS
432: (select 1 from FND_LOOKUP_VALUES
433: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
434: and meaning = ap_lookups.meaning) ;
435:
436: --END IF;

Line 639: INSERT INTO FND_LOOKUP_VALUES

635:
636: LOOP
637:
638:
639: INSERT INTO FND_LOOKUP_VALUES
640: (
641: LOOKUP_TYPE ,
642: LANGUAGE ,
643: LOOKUP_CODE ,

Line 737: from FND_LOOKUP_VALUES

733: LANG.INSTALLED_FLAG IN ('I','B')
734: AND
735: NOT EXISTS
736: (select NULL
737: from FND_LOOKUP_VALUES
738: where lookup_code = codes.LOOKUP_CODE
739: and lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
740: and language =LANG.LANGUAGE_CODE
741: and view_application_id = 0

Line 766: INSERT INTO FND_LOOKUP_VALUES

762:
763: LOOP
764:
765:
766: INSERT INTO FND_LOOKUP_VALUES
767: (
768: LOOKUP_TYPE ,
769: LANGUAGE ,
770: LOOKUP_CODE ,

Line 864: from FND_LOOKUP_VALUES

860: LANG.INSTALLED_FLAG IN ('I','B')
861: AND
862: NOT EXISTS
863: (select NULL
864: from FND_LOOKUP_VALUES
865: where lookup_code = codes.LOOKUP_CODE
866: and lookup_type = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
867: and language =LANG.LANGUAGE_CODE
868: and view_application_id = 0

Line 8473: fnd_lookup_values flv,

8469: taxes.tax_id
8470: FROM
8471: zx_taxes_b taxes,
8472: zx_rates_b rates,
8473: fnd_lookup_values flv,
8474: ap_tax_codes_all ap_code
8475: WHERE
8476: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8477: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8523: fnd_lookup_values flv,

8519: taxes.tax_id
8520: FROM
8521: zx_taxes_b taxes,
8522: zx_rates_b rates,
8523: fnd_lookup_values flv,
8524: ap_tax_codes_all ap_code
8525: WHERE
8526: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8527: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8570: fnd_lookup_values flv,

8566: taxes.tax_id
8567: FROM
8568: zx_taxes_b taxes,
8569: zx_rates_b rates,
8570: fnd_lookup_values flv,
8571: ap_tax_codes_all ap_code
8572: WHERE
8573: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8574: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8617: fnd_lookup_values flv,

8613: taxes.tax_id
8614: FROM
8615: zx_taxes_b taxes,
8616: zx_rates_b rates,
8617: fnd_lookup_values flv,
8618: ap_tax_codes_all ap_code
8619: WHERE
8620: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8621: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE