APPS.FV_SF133_ONEYEAR dependencies on FND_FLEX_VALUE_HIERARCHIES

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

669: ',' || '''' || '-1' || '''' || ') = ' || 'NVL(acct.' || c_flex_column_name
670: ||',NVL(glcc.'||c_flex_column_name ||
671: ','||''''||'-1'||''''||')) ' || '
672: OR glcc.'||c_flex_column_name ||' IN (SELECT flex_value '||
673: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||
674: 'WHERE ffv.flex_value BETWEEN ffvh.child_flex_value_low
675: AND ffvh.child_flex_value_high
676: AND ffv.flex_value_set_id = ' || g_seg_value_set_id ||
677: ' AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||

Line 1980: FROM fnd_flex_value_hierarchies

1976: p_sid NUMBER
1977: ) IS
1978: SELECT child_flex_value_low,
1979: child_flex_value_high
1980: FROM fnd_flex_value_hierarchies
1981: WHERE parent_FLEX_value = p_seg
1982: AND flex_value_set_id = p_sid;
1983:
1984: child_rec child_value_cursor%ROWTYPE;

Line 2064: FROM fnd_flex_value_hierarchies

2060:
2061: IF (v_seg(l_segno) IS NOT NULL) THEN
2062: SELECT COUNT(*)
2063: INTO l_cnt
2064: FROM fnd_flex_value_hierarchies
2065: WHERE parent_flex_value = v_seg(l_segno)
2066: AND flex_value_set_id = flex_rec.flex_value_set_id;
2067:
2068: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN