DBA Data[Home] [Help]

APPS.GL_FLEX_INSERT_PKG dependencies on FND_FLEX_HIERARCHIES_VL

Line 1567: 'fnd_flex_hierarchies_vl fh ' ||

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 ' ||
1571: 'gsh.parent_flex_value = fv.flex_value and ' ||

Line 1948: from fnd_flex_hierarchies_vl

1944:
1945: cursor flexhid(vsid NUMBER,
1946: hname VARCHAR2) is
1947: select hierarchy_id
1948: from fnd_flex_hierarchies_vl
1949: where flex_value_set_id = vsid
1950: and hierarchy_name = hname;
1951:
1952: -- ========================= FND LOG ===========================