APPS.EGO_ITEM_PUB dependencies on EGO_TEMPL_ATTRIBUTES

Line 4182: FROM ego_templ_attributes

4178:
4179: -- get list of attribute groups to check
4180: SELECT DISTINCT attribute_group_id
4181: BULK COLLECT INTO l_attr_group_ids
4182: FROM ego_templ_attributes
4183: WHERE template_id = p_template_id;
4184:
4185: FOR a IN l_attr_group_ids.FIRST .. l_attr_group_ids.LAST
4186: LOOP

Line 4250: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'FROM EGO_TEMPL_ATTRIBUTES T ';

4246: -----------------------------------------------------------------
4247: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' About to call the UCCnet attrs exclude code');
4248: l_attr_grp_dyn_sql := '';
4249: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'SELECT DISTINCT ATTRIBUTE_GROUP_ID ';
4250: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'FROM EGO_TEMPL_ATTRIBUTES T ';
4251: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'WHERE T.TEMPLATE_ID = :TEMPL_ID ';
4252: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'AND ( ';
4253: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' SELECT E.DESCRIPTIVE_FLEXFIELD_NAME ';
4254: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' FROM EGO_FND_DSC_FLX_CTX_EXT E ';