DBA Data[Home] [Help]

APPS.MTL_CATEGORIES_PKG dependencies on FND_APPLICATION

Line 833: WHERE APPLICATION_ID = (select application_id from fnd_application

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'
837: AND ID_FLEX_STRUCTURE_CODE = x_structure_code; /* Bug 6975120

Line 955: WHERE application_id = (select application_id from fnd_application

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

Line 997: WHERE APPLICATION_ID = (select application_id from fnd_application

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'
1001: AND ID_FLEX_STRUCTURE_CODE = x_structure_code;