APPS.GL_FLEX_INSERT_PKG dependencies on GL_SUMMARY_HIERARCHIES

Line 1566: 'from gl_code_combinations cc, gl_summary_hierarchies gsh, fnd_flex_values fv, fnd_id_flex_segments fs, ' ||

1562: sql_stmp := sql_stmp || ' ' ||
1563: 'and (segment' || i || '_type is null ' ||
1564: 'or segment' || i || '_type in (''D'', ''T'') ' ||
1565: 'or segment' || i || '_type in (select fh.hierarchy_name ' ||
1566: 'from gl_code_combinations cc, gl_summary_hierarchies gsh, fnd_flex_values fv, fnd_id_flex_segments fs, ' ||
1567: 'fnd_flex_hierarchies_vl fh ' ||
1568: 'where cc.code_combination_id = :ccid and ' ||
1569: 'cc.segment' || i || ' between gsh.child_flex_value_low and gsh.child_flex_value_high and ' ||
1570: 'gsh.flex_value_set_id = fv.flex_value_set_id and ' ||

Line 2390: -- 2. utilization of new index on gl_summary_hierarchies

2386: -- Bug 4143033
2387: -- ***********
2388: -- c_get_parents modified:
2389: -- 1. join on value_set_id
2390: -- 2. utilization of new index on gl_summary_hierarchies
2391: -- Bug 4191758
2392: -- ***********
2393: -- Added 'distinct' to select of c_get_parents to prevent excessive
2394: -- looping.

Line 2400: FROM gl_summary_hierarchies gsh, fnd_flex_values fv

2396:
2397: DECLARE
2398: CURSOR c_get_parents IS
2399: SELECT DISTINCT gsh.status_code, fv.flex_value
2400: FROM gl_summary_hierarchies gsh, fnd_flex_values fv
2401: WHERE gsh.flex_value_set_id = fv.flex_value_set_id
2402: AND gsh.parent_flex_value = fv.flex_value
2403: AND (seg_val(rgroup_ind(i)) between gsh.child_flex_value_low
2404: and gsh.child_flex_value_high)

Line 2411: l_status_code gl_summary_hierarchies.status_code%type;

2407: AND fv.structured_hierarchy_level = rgroup(rgroup_ind(i))
2408: AND fv.enabled_flag = 'Y';
2409:
2410: l_curr_val fnd_flex_values.flex_value%type;
2411: l_status_code gl_summary_hierarchies.status_code%type;
2412: BEGIN
2413:
2414: -- ========================= FND LOG ===========================
2415: psa_utils.debug_other_string(g_state_level,l_full_path,