APPS.EGO_PUBLICATION_PKG dependencies on EGO_ALL_ATTR_LANG_V

Line 23: FROM EGO_ALL_ATTR_LANG_V

19: CURSOR C1(p_ext_id NUMBER,p_lang VARCHAR2) IS
20: Select xmlElement("Attribute",xmlElement("Id",attribute_id),
21: xmlElement("Name",attribute_name),
22: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))
23: FROM EGO_ALL_ATTR_LANG_V
24: WHERE extension_id =p_ext_id AND ATTRIBUTE_TRANSLATABLE_VALUE IS NOT NULL
25: AND LANGUAGE = p_lang GROUP BY ATTRIBUTE_ID, ATTRIBUTE_NAME;
26:
27:

Line 32: FROM EGO_ALL_ATTR_LANG_V

28: CURSOR C2(p_ext_id NUMBER) IS
29: Select xmlElement("Attribute",xmlElement("Id",attribute_id),
30: xmlElement("Name",attribute_name),
31: xmlAgg(xmlelement("ValueText",xmlattributes(language as "languageID"),attribute_translatable_value)))
32: FROM EGO_ALL_ATTR_LANG_V
33: WHERE extension_id =p_ext_id AND ATTRIBUTE_TRANSLATABLE_VALUE IS NOT NULL
34: GROUP BY ATTRIBUTE_ID, ATTRIBUTE_NAME;
35:
36: CURSOR C3(p_ext_id NUMBER) IS