APPS.JA_CN_SI_BANK_DET_PKG dependencies on FND_FLEX_VALUE_SETS

Line 197: fnd_flex_value_sets s

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
200: AND (((s.format_type = 'N') AND
201: (fnd_number.canonical_to_number(v.flex_value) BETWEEN

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 1210: fnd_flex_value_sets s

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'
1213: AND s.flex_value_set_id = v.flex_value_set_id
1214: AND (((s.format_type = 'N') AND

Line 1292: fnd_flex_value_sets s

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'
1295: AND s.flex_value_set_id = v.flex_value_set_id
1296: AND (((s.format_type = 'N') AND