APPS.FLM_UTIL dependencies on FND_ID_FLEX_SEGMENTS_VL

Line 396: FND_ID_FLEX_SEGMENTS_VL fs

392: CURSOR cur_columns (l_struct_num Number) IS
393: SELECT fs.application_column_name,
394: vs.format_type
395: FROM FND_FLEX_VALUE_SETS vs,
396: FND_ID_FLEX_SEGMENTS_VL fs
397: WHERE fs.application_id = 401
398: AND fs.id_flex_code = 'MCAT'
399: AND fs.id_flex_num = l_struct_num
400: AND fs.enabled_flag = 'Y'

Line 509: FND_ID_FLEX_SEGMENTS_VL fs

505: CURSOR cur_columns (l_struct_num Number) IS
506: SELECT fs.application_column_name,
507: vs.format_type
508: FROM FND_FLEX_VALUE_SETS vs,
509: FND_ID_FLEX_SEGMENTS_VL fs
510: WHERE fs.application_id = 401
511: AND fs.id_flex_code = 'MSTK'
512: AND fs.id_flex_num = l_struct_num
513: AND fs.enabled_flag = 'Y'

Line 528: FROM FND_ID_FLEX_SEGMENTS_VL fs

524: WHERE id_flex_code = 'MSTK';
525:
526: SELECT count(*)
527: INTO l_no_of_segs
528: FROM FND_ID_FLEX_SEGMENTS_VL fs
529: WHERE fs.application_id = 401
530: AND fs.id_flex_code = 'MSTK'
531: AND fs.id_flex_num = l_flex_num
532: AND fs.enabled_flag = 'Y'