APPS.MTL_CATEGORIES_PKG dependencies on FND_APPLICATION

Line 832: WHERE APPLICATION_ID = (select application_id from fnd_application

828: ELSE
829: SELECT ID_FLEX_NUM
830: INTO l_structure_id
831: FROM FND_ID_FLEX_STRUCTURES
832: WHERE APPLICATION_ID = (select application_id from fnd_application
833: where application_short_name =
834: x_application_short_name)
835: AND ID_FLEX_CODE = 'MCAT'
836: AND ID_FLEX_STRUCTURE_CODE = x_structure_code; /* Bug 6975120

Line 954: WHERE application_id = (select application_id from fnd_application

950:
951: CURSOR get_segments(l_structure_id NUMBER) is
952: SELECT application_column_name,rownum
953: FROM fnd_id_flex_segments
954: WHERE application_id = (select application_id from fnd_application
955: where application_short_name =
956: x_application_short_name)
957: AND id_flex_code = 'MCAT'
958: AND id_flex_num = l_structure_id

Line 996: WHERE APPLICATION_ID = (select application_id from fnd_application

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