APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_FLEX_VALUES_VL

Line 195: FROM fnd_flex_values_vl v,

191: v.flex_value,
192: v.description,
193: v.summary_flag,
194: v.HIERARCHY_LEVEL
195: FROM fnd_flex_values_vl v,
196: fnd_flex_value_norm_hierarchy h,
197: fnd_flex_value_sets s
198: WHERE h.flex_value_set_id = v.flex_value_set_id
199: AND s.flex_value_set_id = v.flex_value_set_id

Line 330: from fnd_flex_values_vl ffv

326:
327: IF l_row_count = 0 THEN
328: select ffv.flex_value, ffv.description,ffv.HIERARCHY_LEVEL
329: into l_single_vale, l_single_desc,l_level
330: from fnd_flex_values_vl ffv
331: where ffv.FLEX_VALUE_SET_ID =
332: (SELECT fifsv.FLEX_VALUE_SET_ID
333: FROM FND_ID_FLEX_SEGMENTS_VL fifsv,
334: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

Line 441: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv

437:
438: --get bsv summary
439: SELECT SUMMARY_FLAG
440: INTO lv_summary
441: FROM FND_FLEX_VALUE_SETS ffs, FND_FLEX_VALUES_VL ffv
442: WHERE ffs.flex_value_set_id = ffv.FLEX_VALUE_SET_ID
443: AND ffv.FLEX_VALUE_SET_ID = l_flex_valueset_id
444: AND ffv.FLEX_VALUE = l_bsv_temp;
445: --child

Line 1208: FROM fnd_flex_values_vl v,

1204: h.parent_flex_value,
1205: v.flex_value,
1206: v.description,
1207: v.summary_flag
1208: FROM fnd_flex_values_vl v,
1209: fnd_flex_value_norm_hierarchy h,
1210: fnd_flex_value_sets s
1211: WHERE h.flex_value_set_id = v.flex_value_set_id
1212: AND v.ENABLED_FLAG = 'Y'

Line 1290: FROM fnd_flex_values_vl v,

1286: h.parent_flex_value,
1287: v.flex_value,
1288: v.description,
1289: v.summary_flag
1290: FROM fnd_flex_values_vl v,
1291: fnd_flex_value_norm_hierarchy h,
1292: fnd_flex_value_sets s
1293: WHERE h.flex_value_set_id = v.flex_value_set_id
1294: AND v.ENABLED_FLAG = 'Y'