APPS.RRS_BULKLOAD_ENTITIES dependencies on EGO_RESULTS_FMT_USAGES

Line 206: FROM ego_results_fmt_usages

202: p_entity_name IN VARCHAR2
203: ) Is
204: CURSOR c_user_attr_group_codes (c_resultfmt_usage_id IN NUMBER,c_attr_group_type IN VARCHAR2) IS
205: SELECT DISTINCT To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) attr_group_id,classification_code
206: FROM ego_results_fmt_usages
207: WHERE resultfmt_usage_id = c_resultfmt_usage_id
208: AND attribute_code LIKE '%$$%'
209: AND To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, '$$') - 1)) IN
210: (

Line 342: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';

338: )
339: LOOP
340: l_dyn_sql := '';
341: l_dyn_sql := ' SELECT To_Number(SUBSTR(attribute_code, INSTR(attribute_code, ''$$'')+2)) attr_id, intf_column_name, To_Number(SUBSTR(attribute_code, 1, INSTR(attribute_code, ''$$'') - 1)) attr_group_id '; --bug 6493113
342: l_dyn_sql := l_dyn_sql || ' FROM ego_results_fmt_usages ';
343: l_dyn_sql := l_dyn_sql || ' WHERE resultfmt_usage_id = :RESULTFMT_USAGE_ID';
344: l_dyn_sql := l_dyn_sql || ' AND attribute_code LIKE :ATTRIBUTE_CODE ';
345: l_cursor_select := DBMS_SQL.OPEN_CURSOR;
346: DBMS_SQL.PARSE(l_cursor_select, l_dyn_sql, DBMS_SQL.NATIVE);