APPS.ZX_PTP_MIGRATE_PKG dependencies on ZX_FC_TYPES_B

Line 2352: INTO ZX_FC_TYPES_B(

2348:
2349: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );
2350:
2351: INSERT ALL
2352: INTO ZX_FC_TYPES_B(
2353: CLASSIFICATION_TYPE_ID,
2354: OWNER_TABLE_CODE,
2355: OWNER_ID_CHAR,
2356: CLASSIFICATION_TYPE_CODE,

Line 2373: ZX_FC_TYPES_B_S.NEXTVAL,

2369: LAST_UPDATE_DATE,
2370: LAST_UPDATE_LOGIN,
2371: OBJECT_VERSION_NUMBER)
2372: VALUES (
2373: ZX_FC_TYPES_B_S.NEXTVAL,
2374: 'HZ_CLASS_CATEGORY',
2375: 'VENDOR TYPE',
2376: 'SUPPLIER_TYPE',
2377: 'PARTY_FISCAL_CLASS',

Line 2395: FROM ZX_FC_TYPES_B TYPE

2391: 1)
2392: SELECT '1' from dual
2393: WHERE NOT EXISTS
2394: (SELECT NULL
2395: FROM ZX_FC_TYPES_B TYPE
2396: WHERE TYPE.CLASSIFICATION_TYPE_CODE =
2397: 'SUPPLIER_TYPE' AND
2398: TYPE.CLASSIFICATION_TYPE_CATEG_CODE =
2399: 'PARTY_FISCAL_CLASS');

Line 2427: ZX_FC_TYPES_B fc_types

2423: fc_types.CLASSIFICATION_TYPE_ID ,
2424: L.LANGUAGE_CODE
2425: FROM
2426: FND_LANGUAGES L,
2427: ZX_FC_TYPES_B fc_types
2428: WHERE
2429: L.INSTALLED_FLAG in ('I', 'B')
2430: AND fc_types.RECORD_TYPE_CODE = 'MIGRATED'
2431: AND fc_types.CLASSIFICATION_TYPE_CODE