DBA Data[Home] [Help]

APPS.AS_CATALOG_MIGRATION dependencies on FND_ID_FLEX_STRUCTURES

Line 201: from FND_ID_FLEX_STRUCTURES FIFS

197:
198: BEGIN
199: -- Get structure id corresponding to sales and marketing category set
200: select FIFS.ID_FLEX_NUM into l_old_structure_id
201: from FND_ID_FLEX_STRUCTURES FIFS
202: where FIFS.ID_FLEX_CODE = 'MCAT' AND FIFS.APPLICATION_ID = 401 AND FIFS.ID_FLEX_STRUCTURE_CODE = 'SALES_CATEGORIES';
203: EXCEPTION
204: WHEN OTHERS THEN
205: FND_FILE.PUT_LINE(FND_FILE.LOG,'Unable to find structure id corresponding to sales and marketing category set');