APPS.EGO_PUBLICATION_PKG dependencies on MTL_CATEGORY_SETS_TL

Line 633: FROM mtl_category_sets_tl

629:
630: IF (p_language IS NOT NULL) THEN
631:
632: x_query := 'SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))
633: FROM mtl_category_sets_tl
634: WHERE category_set_id = '|| cat_set_id || 'AND language = '|| '''' || p_language || '''' ;
635:
636: Execute Immediate x_query
637: INTO x_desc;

Line 643: FROM mtl_category_sets_tl

639: ELSE
640:
641: SELECT XMLAGG(XMLELEMENT("Description",XMLATTRIBUTES(LANGUAGE AS "LanguageID"),DESCRIPTION))
642: INTO x_desc
643: FROM mtl_category_sets_tl
644: WHERE category_set_id =cat_set_id;
645: END IF;
646:
647: ----- Generate CATALOGBASE ELEMENT -------------------------------------