APPS.MTL_CATEGORIES_PKG dependencies on FND_ID_FLEX_STRUCTURES

Line 832: FROM FND_ID_FLEX_STRUCTURES

828: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
829: ELSE
830: SELECT ID_FLEX_NUM
831: INTO l_structure_id
832: FROM FND_ID_FLEX_STRUCTURES
833: WHERE APPLICATION_ID = (select application_id from fnd_application
834: where application_short_name =
835: x_application_short_name)
836: AND ID_FLEX_CODE = 'MCAT'

Line 898: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120

894:
895: PROCEDURE Load_Row
896: (
897: x_CATEGORY_NAME IN MTL_CATEGORIES_KFV.CONCATENATED_SEGMENTS%TYPE
898: ,x_STRUCTURE_CODE IN FND_ID_FLEX_STRUCTURES.ID_FLEX_STRUCTURE_CODE%TYPE --BUG 6975120
899: ,X_SEGMENT1 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
900: ,X_SEGMENT2 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
901: ,X_SEGMENT3 IN MTL_CATEGORIES_B.SEGMENT1%TYPE
902: ,X_SEGMENT4 IN MTL_CATEGORIES_B.SEGMENT1%TYPE

Line 996: FROM FND_ID_FLEX_STRUCTURES

992: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;
993: ELSE
994: SELECT ID_FLEX_NUM
995: INTO l_structure_id
996: FROM FND_ID_FLEX_STRUCTURES
997: WHERE APPLICATION_ID = (select application_id from fnd_application
998: where application_short_name =
999: x_application_short_name)
1000: AND ID_FLEX_CODE = 'MCAT'