APPS.FV_SF133_NOYEAR dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 589: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||

585: ',' || '''' || '-1' || '''' || ') = ' || 'NVL(acct.' || c_flex_column_name
586: ||',NVL(glcc.'||c_flex_column_name ||
587: ','||''''||'-1'||''''||')) ' || '
588: OR glcc.'||c_flex_column_name ||' IN (SELECT flex_value '||
589: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||
590: 'WHERE ffv.flex_value BETWEEN ffvh.child_flex_value_low
591: AND ffvh.child_flex_value_high
592: AND ffv.flex_value_set_id = ' || g_seg_value_set_id ||
593: ' AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||

Line 1589: FROM fnd_flex_value_hierarchies

1585: p_sid NUMBER
1586: ) IS
1587: SELECT child_flex_value_low,
1588: child_flex_value_high
1589: FROM fnd_flex_value_hierarchies
1590: WHERE parent_FLEX_value = p_seg
1591: AND flex_value_set_id = p_sid;
1592:
1593: child_rec child_value_cursor%ROWTYPE;

Line 1673: FROM fnd_flex_value_hierarchies

1669:
1670: IF (v_seg(l_segno) IS NOT NULL) THEN
1671: SELECT COUNT(*)
1672: INTO l_cnt
1673: FROM fnd_flex_value_hierarchies
1674: WHERE parent_flex_value = v_seg(l_segno)
1675: AND flex_value_set_id = flex_rec.flex_value_set_id;
1676:
1677: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN