APPS.INVPUTLI dependencies on FND_ID_FLEX_SEGMENTS

Line 78: FROM fnd_id_flex_segments fs

74: END LOOP;
75:
76: SELECT MAX(fs.segment_num), COUNT(*)
77: INTO max_segment, totalsegs
78: FROM fnd_id_flex_segments fs
79: WHERE fs.application_id = l_application_id
80: AND fs.id_flex_code = l_id_flex_code
81: AND fs.enabled_flag = l_enabled_flag
82: AND fs.id_flex_num = l_id_flex_num;

Line 93: FROM fnd_id_flex_segments fs

89: BEGIN
90:
91: SELECT TO_NUMBER(SUBSTR(fs.application_column_name, 8)), required_flag
92: INTO segnum, l_required_flag
93: FROM fnd_id_flex_segments fs
94: WHERE fs.segment_num = n
95: AND fs.id_flex_code = l_id_flex_code
96: AND fs.id_flex_num = l_id_flex_num
97: AND fs.enabled_flag = l_enabled_flag