160: --
161: -- Local cursors
162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS
161: -- Local cursors
162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS
169: SELECT ifs.application_column_name
162: --
163: CURSOR csr_id_flex_segments
164: (p_application_id IN fnd_id_flex_segments.application_id%TYPE
165: ,p_id_flex_code IN fnd_id_flex_segments.id_flex_code%TYPE
166: ,p_id_flex_num IN fnd_id_flex_segments.id_flex_num%TYPE
167: )
168: IS
169: SELECT ifs.application_column_name
170: ,ifs.segment_num
179: ,ifs.form_left_prompt
180: ,ifs.maximum_description_len
181: ,ifs.required_flag
182: ,ifs.segment_name
183: FROM fnd_id_flex_segments_vl ifs
184: ,fnd_id_flex_structures fst
185: WHERE ifs.application_id = fst.application_id
186: AND ifs.id_flex_code = fst.id_flex_code
187: AND ifs.id_flex_num = fst.id_flex_num