APPS.FV_SF133_ONEYEAR dependencies on FND_FLEX_VALUE_HIERARCHIES

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

498: ',' || '''' || '-1' || '''' || ') = ' || 'NVL(acct.' || c_flex_column_name
499: ||',NVL(glcc.'||c_flex_column_name ||
500: ','||''''||'-1'||''''||')) ' || '
501: OR glcc.'||c_flex_column_name ||' IN (SELECT flex_value '||
502: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||
503: 'WHERE ffv.flex_value BETWEEN ffvh.child_flex_value_low
504: AND ffvh.child_flex_value_high
505: AND ffv.flex_value_set_id = ' || g_seg_value_set_id ||
506: ' AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||

Line 1482: FROM fnd_flex_value_hierarchies

1478: p_sid NUMBER
1479: ) IS
1480: SELECT child_flex_value_low,
1481: child_flex_value_high
1482: FROM fnd_flex_value_hierarchies
1483: WHERE parent_FLEX_value = p_seg
1484: AND flex_value_set_id = p_sid;
1485:
1486: child_rec child_value_cursor%ROWTYPE;

Line 1566: FROM fnd_flex_value_hierarchies

1562:
1563: IF (v_seg(l_segno) IS NOT NULL) THEN
1564: SELECT COUNT(*)
1565: INTO l_cnt
1566: FROM fnd_flex_value_hierarchies
1567: WHERE parent_flex_value = v_seg(l_segno)
1568: AND flex_value_set_id = flex_rec.flex_value_set_id;
1569:
1570: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN