APPS.EGO_ITEM_PUB dependencies on EGO_TEMPL_ATTRIBUTES

Line 3934: FROM ego_templ_attributes

3930:
3931: -- get list of attribute groups to check
3932: SELECT DISTINCT attribute_group_id
3933: BULK COLLECT INTO l_attr_group_ids
3934: FROM ego_templ_attributes
3935: WHERE template_id = p_template_id;
3936:
3937: FOR a IN l_attr_group_ids.FIRST .. l_attr_group_ids.LAST
3938: LOOP

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

3998: -----------------------------------------------------------------
3999: EGO_USER_ATTRS_DATA_PVT.Debug_Msg(' About to call the UCCnet attrs exclude code');
4000: l_attr_grp_dyn_sql := '';
4001: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'SELECT DISTINCT ATTRIBUTE_GROUP_ID ';
4002: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'FROM EGO_TEMPL_ATTRIBUTES T ';
4003: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'WHERE T.TEMPLATE_ID = :TEMPL_ID ';
4004: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || 'AND ( ';
4005: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' SELECT E.DESCRIPTIVE_FLEXFIELD_NAME ';
4006: l_attr_grp_dyn_sql := l_attr_grp_dyn_sql || ' FROM EGO_FND_DSC_FLX_CTX_EXT E ';