APPS.ZX_MIGRATE_TAX_DEF dependencies on FND_LOOKUP_VALUES

Line 279: INSERT INTO FND_LOOKUP_VALUES

275: FROM ap_tax_codes_all;
276:
277: IF l_cnt <> 0 THEN*/
278: BEGIN
279: INSERT INTO FND_LOOKUP_VALUES
280: (
281: LOOKUP_TYPE ,
282: LANGUAGE ,
283: LOOKUP_CODE ,

Line 351: FROM FND_LOOKUP_VALUES ap_lookups

347: fnd_global.user_id ,
348: SYSDATE ,
349: fnd_global.user_id ,
350: fnd_global.conc_login_id
351: FROM FND_LOOKUP_VALUES ap_lookups
352: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
353: AND NOT EXISTS
354: (select 1 from FND_LOOKUP_VALUES
355: where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'

Line 354: (select 1 from FND_LOOKUP_VALUES

350: fnd_global.conc_login_id
351: FROM FND_LOOKUP_VALUES ap_lookups
352: WHERE ap_lookups.LOOKUP_TYPE = 'JEBE_VAT_TRANS_TYPE'
353: AND NOT EXISTS
354: (select 1 from FND_LOOKUP_VALUES
355: where lookup_type = 'ZX_JEBE_VAT_TRANS_TYPE'
356: and lookup_code = ap_lookups.lookup_code);
357: EXCEPTION
358: WHEN OTHERS THEN

Line 376: INSERT INTO FND_LOOKUP_VALUES

372: FROM ap_tax_codes_all;
373:
374: IF l_cnt <> 0 THEN*/
375:
376: INSERT INTO FND_LOOKUP_VALUES
377: (
378: LOOKUP_TYPE ,
379: LANGUAGE ,
380: LOOKUP_CODE ,

Line 448: FROM FND_LOOKUP_VALUES ap_lookups

444: fnd_global.user_id ,
445: SYSDATE ,
446: fnd_global.user_id ,
447: fnd_global.conc_login_id
448: FROM FND_LOOKUP_VALUES ap_lookups
449: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
450: -- Changed the re-runnability check
451: AND NOT EXISTS
452: (select 1 from FND_LOOKUP_VALUES

Line 452: (select 1 from FND_LOOKUP_VALUES

448: FROM FND_LOOKUP_VALUES ap_lookups
449: WHERE ap_lookups.LOOKUP_TYPE = 'TAX TYPE'
450: -- Changed the re-runnability check
451: AND NOT EXISTS
452: (select 1 from FND_LOOKUP_VALUES
453: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
454: and lookup_code = ap_lookups.lookup_code)
455: and NOT EXISTS
456: (select 1 from FND_LOOKUP_VALUES

Line 456: (select 1 from FND_LOOKUP_VALUES

452: (select 1 from FND_LOOKUP_VALUES
453: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
454: and lookup_code = ap_lookups.lookup_code)
455: and NOT EXISTS
456: (select 1 from FND_LOOKUP_VALUES
457: where lookup_type = 'ZX_TAX_TYPE_CATEGORY'
458: and meaning = ap_lookups.meaning) ;
459:
460: --END IF;

Line 663: INSERT INTO FND_LOOKUP_VALUES

659:
660: LOOP
661:
662:
663: INSERT INTO FND_LOOKUP_VALUES
664: (
665: LOOKUP_TYPE ,
666: LANGUAGE ,
667: LOOKUP_CODE ,

Line 761: from FND_LOOKUP_VALUES

757: LANG.INSTALLED_FLAG IN ('I','B')
758: AND
759: NOT EXISTS
760: (select NULL
761: from FND_LOOKUP_VALUES
762: where lookup_code = codes.LOOKUP_CODE
763: and lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
764: and language =LANG.LANGUAGE_CODE
765: and view_application_id = 0

Line 790: INSERT INTO FND_LOOKUP_VALUES

786:
787: LOOP
788:
789:
790: INSERT INTO FND_LOOKUP_VALUES
791: (
792: LOOKUP_TYPE ,
793: LANGUAGE ,
794: LOOKUP_CODE ,

Line 883: from FND_LOOKUP_VALUES

879: LANG.INSTALLED_FLAG IN ('I','B')
880: AND
881: NOT EXISTS
882: (select NULL
883: from FND_LOOKUP_VALUES
884: where lookup_code = codes.LOOKUP_CODE
885: and lookup_type = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS'
886: and language =LANG.LANGUAGE_CODE
887: and view_application_id = 0

Line 8495: fnd_lookup_values flv,

8491: taxes.tax_id
8492: FROM
8493: zx_taxes_b taxes,
8494: zx_rates_b rates,
8495: fnd_lookup_values flv,
8496: ap_tax_codes_all ap_code
8497: WHERE
8498: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8499: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8545: fnd_lookup_values flv,

8541: taxes.tax_id
8542: FROM
8543: zx_taxes_b taxes,
8544: zx_rates_b rates,
8545: fnd_lookup_values flv,
8546: ap_tax_codes_all ap_code
8547: WHERE
8548: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8549: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8592: fnd_lookup_values flv,

8588: taxes.tax_id
8589: FROM
8590: zx_taxes_b taxes,
8591: zx_rates_b rates,
8592: fnd_lookup_values flv,
8593: ap_tax_codes_all ap_code
8594: WHERE
8595: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8596: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE

Line 8639: fnd_lookup_values flv,

8635: taxes.tax_id
8636: FROM
8637: zx_taxes_b taxes,
8638: zx_rates_b rates,
8639: fnd_lookup_values flv,
8640: ap_tax_codes_all ap_code
8641: WHERE
8642: taxes.CONTENT_OWNER_ID = rates.CONTENT_OWNER_ID
8643: AND taxes.TAX_REGIME_CODE = rates.TAX_REGIME_CODE