DBA Data[Home] [Help]

APPS.EGO_CATEGORY_SET_PUB dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 111: from mtl_default_category_sets

107:
108: l_default_exists := 'N';
109:
110: select count(1) into l_exists
111: from mtl_default_category_sets
112: where functional_area_id = G_DBI_FUNCTIONAL_AREA_ID;
113:
114: if (l_exists <> 0 ) then
115: -- default exists

Line 143: (select * from mtl_default_category_sets

139: IF( l_default_exists = 'Y' ) THEN
140:
141: SELECT category_set_id INTO l_DBI_category_set_id
142: FROM
143: (select * from mtl_default_category_sets
144: where functional_area_id = EGO_CATEGORY_SET_PUB.G_DBI_FUNCTIONAL_AREA_ID
145: and rownum = 1);
146:
147: END IF;