APPS.IGS_CO_MAPPING_PKG dependencies on IBC_CTYPE_GROUP_NODES

Line 140: (SELECT CONTENT_TYPE_CODE FROM IBC_CTYPE_GROUP_NODES WHERE

136: SELECT COUNT(content_item_id)
137: FROM IBC_CONTENT_ITEMS
138: WHERE CONTENT_ITEM_ID = cp_id AND
139: EXISTS
140: (SELECT CONTENT_TYPE_CODE FROM IBC_CTYPE_GROUP_NODES WHERE
141: DIRECTORY_NODE_ID IN (32,33,34));
142:
143: l_list_item NUMBER;
144: l_doc_item NUMBER;