APPS.INVPUTLI dependencies on FND_ID_FLEX_SEGMENTS

Line 83: FROM fnd_id_flex_segments fs

79: END LOOP;
80:
81: SELECT MAX(fs.segment_num), COUNT(*)
82: INTO max_segment, totalsegs
83: FROM fnd_id_flex_segments fs
84: WHERE fs.application_id = l_application_id
85: AND fs.id_flex_code = l_id_flex_code
86: AND fs.enabled_flag = l_enabled_flag
87: AND fs.id_flex_num = l_id_flex_num;

Line 98: FROM fnd_id_flex_segments fs

94: BEGIN
95:
96: SELECT TO_NUMBER(SUBSTR(fs.application_column_name, 8)), required_flag
97: INTO segnum, l_required_flag
98: FROM fnd_id_flex_segments fs
99: WHERE fs.segment_num = n
100: AND fs.id_flex_code = l_id_flex_code
101: AND fs.id_flex_num = l_id_flex_num
102: AND fs.enabled_flag = l_enabled_flag