APPS.AS_CATALOG_MIGRATION dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 538: from MTL_CATEGORY_SETS S, MTL_DEFAULT_CATEGORY_SETS D

534: where category_set_name = G_SME_CATEGORY_SET_NAME;
535:
536: CURSOR C_Check_Functional_Area(c_category_set_id NUMBER) IS
537: select 1
538: from MTL_CATEGORY_SETS S, MTL_DEFAULT_CATEGORY_SETS D
539: where S.category_set_id = D.category_set_id
540: and D.functional_area_id = G_FUNCTIONAL_AREA
541: and D.category_set_id = c_category_set_id;
542:

Line 591: from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS C

587: end if;
588:
589: -- Get structure id and control level associated with functional area 11
590: select C.structure_id, C.control_level into l_structure_id, l_control_level
591: from MTL_DEFAULT_CATEGORY_SETS D, MTL_CATEGORY_SETS C
592: where D.functional_area_id = G_FUNCTIONAL_AREA and D.category_set_id = C.category_set_id;
593:
594: select MTL_CATEGORY_SETS_S.NEXTVAL into l_next_val from dual;
595:

Line 695: Update MTL_DEFAULT_CATEGORY_SETS

691: IF G_debug and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) then
692: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT,'as.plsql.conc.asxmcatb', 'Attaching Category Set to functional area 11');
693: end if;
694:
695: Update MTL_DEFAULT_CATEGORY_SETS
696: set category_set_id = p_category_set_id
697: where functional_area_id = G_FUNCTIONAL_AREA;
698:
699: -- If nothing updated then this is an error