APPS.FV_SF133_NOYEAR dependencies on FND_FLEX_VALUE_HIERARCHIES

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

470: ',' || '''' || '-1' || '''' || ') = ' || 'NVL(acct.' || c_flex_column_name
471: ||',NVL(glcc.'||c_flex_column_name ||
472: ','||''''||'-1'||''''||')) ' || '
473: OR glcc.'||c_flex_column_name ||' IN (SELECT flex_value '||
474: 'FROM fnd_flex_values ffv, fnd_flex_value_hierarchies ffvh '||
475: 'WHERE ffv.flex_value BETWEEN ffvh.child_flex_value_low
476: AND ffvh.child_flex_value_high
477: AND ffv.flex_value_set_id = ' || g_seg_value_set_id ||
478: ' AND ffv.flex_value_set_id = ffvh.flex_value_set_id'||

Line 1112: FROM fnd_flex_value_hierarchies

1108: p_sid NUMBER
1109: ) IS
1110: SELECT child_flex_value_low,
1111: child_flex_value_high
1112: FROM fnd_flex_value_hierarchies
1113: WHERE parent_FLEX_value = p_seg
1114: AND flex_value_set_id = p_sid;
1115:
1116: child_rec child_value_cursor%ROWTYPE;

Line 1196: FROM fnd_flex_value_hierarchies

1192:
1193: IF (v_seg(l_segno) IS NOT NULL) THEN
1194: SELECT COUNT(*)
1195: INTO l_cnt
1196: FROM fnd_flex_value_hierarchies
1197: WHERE parent_flex_value = v_seg(l_segno)
1198: AND flex_value_set_id = flex_rec.flex_value_set_id;
1199:
1200: IF ( fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN