APPS.ZX_PTP_CUST_MIG_PKG dependencies on FND_LOOKUP_TYPES

Line 321: (SELECT 1 FROM FND_LOOKUP_TYPES

317: END IF;
318:
319: INSERT ALL
320: WHEN (NOT EXISTS
321: (SELECT 1 FROM FND_LOOKUP_TYPES
322: WHERE LOOKUP_TYPE = 'ZX_PTPTR_GEO_TYPE_CLASS')
323: ) THEN
324: INTO FND_LOOKUP_TYPES
325: (

Line 324: INTO FND_LOOKUP_TYPES

320: WHEN (NOT EXISTS
321: (SELECT 1 FROM FND_LOOKUP_TYPES
322: WHERE LOOKUP_TYPE = 'ZX_PTPTR_GEO_TYPE_CLASS')
323: ) THEN
324: INTO FND_LOOKUP_TYPES
325: (
326: APPLICATION_ID ,
327: LOOKUP_TYPE ,
328: CUSTOMIZATION_LEVEL ,

Line 352: INSERT INTO FND_LOOKUP_TYPES_TL

348: fnd_global.conc_login_id
349: )
350: SELECT 1 FROM DUAL;
351:
352: INSERT INTO FND_LOOKUP_TYPES_TL
353: (
354: LOOKUP_TYPE,
355: SECURITY_GROUP_ID,
356: VIEW_APPLICATION_ID,

Line 380: FROM FND_LOOKUP_TYPES types, FND_LANGUAGES L

376: SYSDATE ,
377: fnd_global.user_id ,
378: SYSDATE ,
379: fnd_global.conc_login_id
380: FROM FND_LOOKUP_TYPES types, FND_LANGUAGES L
381: WHERE L.INSTALLED_FLAG in ('I', 'B')
382: AND types.lookup_type = 'ZX_PTPTR_GEO_TYPE_CLASS'
383: AND not exists
384: (select '1'

Line 385: from fnd_lookup_types_tl sub

381: WHERE L.INSTALLED_FLAG in ('I', 'B')
382: AND types.lookup_type = 'ZX_PTPTR_GEO_TYPE_CLASS'
383: AND not exists
384: (select '1'
385: from fnd_lookup_types_tl sub
386: where sub.lookup_type = 'ZX_PTPTR_GEO_TYPE_CLASS'
387: and sub.security_group_id = 0
388: and sub.view_application_id = 0
389: and sub.language = l.language_code);