APPS.ZX_PTP_MIGRATE_PKG dependencies on ZX_FC_TYPES_B

Line 2472: INTO ZX_FC_TYPES_B(

2468:
2469: arp_util_tax.debug(' Creating Fiscal classification types .. (+) ' );
2470:
2471: INSERT ALL
2472: INTO ZX_FC_TYPES_B(
2473: CLASSIFICATION_TYPE_ID,
2474: OWNER_TABLE_CODE,
2475: OWNER_ID_CHAR,
2476: CLASSIFICATION_TYPE_CODE,

Line 2493: ZX_FC_TYPES_B_S.NEXTVAL,

2489: LAST_UPDATE_DATE,
2490: LAST_UPDATE_LOGIN,
2491: OBJECT_VERSION_NUMBER)
2492: VALUES (
2493: ZX_FC_TYPES_B_S.NEXTVAL,
2494: 'HZ_CLASS_CATEGORY',
2495: 'VENDOR TYPE',
2496: 'SUPPLIER_TYPE',
2497: 'PARTY_FISCAL_CLASS',

Line 2515: FROM ZX_FC_TYPES_B TYPE

2511: 1)
2512: SELECT '1' from dual
2513: WHERE NOT EXISTS
2514: (SELECT NULL
2515: FROM ZX_FC_TYPES_B TYPE
2516: WHERE TYPE.CLASSIFICATION_TYPE_CODE =
2517: 'SUPPLIER_TYPE' AND
2518: TYPE.CLASSIFICATION_TYPE_CATEG_CODE =
2519: 'PARTY_FISCAL_CLASS');

Line 2547: ZX_FC_TYPES_B fc_types

2543: fc_types.CLASSIFICATION_TYPE_ID ,
2544: L.LANGUAGE_CODE
2545: FROM
2546: FND_LANGUAGES L,
2547: ZX_FC_TYPES_B fc_types
2548: WHERE
2549: L.INSTALLED_FLAG in ('I', 'B')
2550: AND fc_types.RECORD_TYPE_CODE = 'MIGRATED'
2551: AND fc_types.CLASSIFICATION_TYPE_CODE