APPS.ZX_MIGRATE_TAX_DEF dependencies on FND_LOOKUP_TYPES

Line 486: (SELECT 1 FROM FND_LOOKUP_TYPES

482: /* For AP and AR LookupType */
483:
484: INSERT ALL
485: WHEN (NOT EXISTS
486: (SELECT 1 FROM FND_LOOKUP_TYPES
487: WHERE LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS')
488: ) THEN
489: INTO FND_LOOKUP_TYPES
490: (

Line 489: INTO FND_LOOKUP_TYPES

485: WHEN (NOT EXISTS
486: (SELECT 1 FROM FND_LOOKUP_TYPES
487: WHERE LOOKUP_TYPE = 'ZX_INPUT_CLASSIFICATIONS')
488: ) THEN
489: INTO FND_LOOKUP_TYPES
490: (
491: APPLICATION_ID ,
492: LOOKUP_TYPE ,
493: CUSTOMIZATION_LEVEL ,

Line 516: (SELECT 1 FROM FND_LOOKUP_TYPES

512: fnd_global.user_id ,
513: fnd_global.conc_login_id
514: )
515: WHEN (NOT EXISTS
516: (SELECT 1 FROM FND_LOOKUP_TYPES
517: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')
518: ) THEN
519: INTO FND_LOOKUP_TYPES
520: (

Line 519: INTO FND_LOOKUP_TYPES

515: WHEN (NOT EXISTS
516: (SELECT 1 FROM FND_LOOKUP_TYPES
517: WHERE LOOKUP_TYPE = 'ZX_OUTPUT_CLASSIFICATIONS')
518: ) THEN
519: INTO FND_LOOKUP_TYPES
520: (
521: APPLICATION_ID ,
522: LOOKUP_TYPE ,
523: CUSTOMIZATION_LEVEL ,

Line 546: (SELECT 1 FROM FND_LOOKUP_TYPES

542: fnd_global.user_id ,
543: fnd_global.conc_login_id
544: )
545: WHEN (NOT EXISTS
546: (SELECT 1 FROM FND_LOOKUP_TYPES
547: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
548: ) THEN
549: INTO FND_LOOKUP_TYPES
550: (

Line 549: INTO FND_LOOKUP_TYPES

545: WHEN (NOT EXISTS
546: (SELECT 1 FROM FND_LOOKUP_TYPES
547: WHERE LOOKUP_TYPE = 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
548: ) THEN
549: INTO FND_LOOKUP_TYPES
550: (
551: APPLICATION_ID ,
552: LOOKUP_TYPE ,
553: CUSTOMIZATION_LEVEL ,

Line 577: INSERT INTO FND_LOOKUP_TYPES_TL

573: fnd_global.conc_login_id
574: )
575: SELECT 1 FROM DUAL;
576:
577: INSERT INTO FND_LOOKUP_TYPES_TL
578: (
579: LOOKUP_TYPE,
580: SECURITY_GROUP_ID,
581: VIEW_APPLICATION_ID,

Line 609: FROM FND_LOOKUP_TYPES types,

605: SYSDATE ,
606: fnd_global.user_id ,
607: SYSDATE ,
608: fnd_global.conc_login_id
609: FROM FND_LOOKUP_TYPES types,
610: FND_LANGUAGES L
611: WHERE L.INSTALLED_FLAG in ('I', 'B')
612: AND types.lookup_type in ('ZX_OUTPUT_CLASSIFICATIONS',
613: 'ZX_INPUT_CLASSIFICATIONS',

Line 617: from fnd_lookup_types_tl sub

613: 'ZX_INPUT_CLASSIFICATIONS',
614: 'ZX_WEB_EXP_TAX_CLASSIFICATIONS')
615: AND not exists
616: (select null
617: from fnd_lookup_types_tl sub
618: where sub.lookup_type = types.lookup_type
619: and sub.security_group_id = 0
620: and sub.view_application_id = 0
621: and sub.language = l.language_code);