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: nvl(vs.format_type,'S') 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: nvl(vs.format_type,'S') 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 529: FROM FND_ID_FLEX_SEGMENTS_VL fs

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