APPS.MTL_CATEGORIES_PKG dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 824: FROM MTL_DEFAULT_CATEGORY_SETS A,

820:
821: IF x_upload_to_functional_area <> '-1' THEN
822: SELECT B.STRUCTURE_ID
823: INTO l_structure_id
824: FROM MTL_DEFAULT_CATEGORY_SETS A,
825: MTL_CATEGORY_SETS_B B
826: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
827: where lookup_type = 'MTL_FUNCTIONAL_AREAS' and upper(meaning) = upper(x_upload_to_functional_area))
828: AND A.CATEGORY_SET_ID = B.CATEGORY_SET_ID;

Line 987: FROM MTL_DEFAULT_CATEGORY_SETS A,

983:
984: IF x_upload_to_functional_area <> '-1' THEN
985: SELECT A.CATEGORY_SET_ID, B.STRUCTURE_ID
986: INTO l_category_set_id, l_structure_id
987: FROM MTL_DEFAULT_CATEGORY_SETS A,
988: MTL_CATEGORY_SETS B
989: WHERE FUNCTIONAL_AREA_ID = (select lookup_code from mfg_lookups
990: where lookup_type = 'MTL_FUNCTIONAL_AREAS'
991: and upper(meaning) = upper(x_upload_to_functional_area))