197: /**********************************************************************/
198: -- Query to get the Validation Type for Value Set : bug:7641746
199: CURSOR c_validation_type(p_flex_value_set_id IN NUMBER) IS
200: select validation_type
201: from fnd_flex_value_sets
202: where flex_value_set_id = p_flex_value_set_id ;
203:
204: -- Query to get the parent SEGMENT for Dependent Value Set : bug:7641746
205: CURSOR c_parent_segment_name(p_flex_value_set_id IN NUMBER) IS
209: AND id_flex_num = p_coa_id
210: AND application_id = 101
211: AND flex_value_set_id =
212: ( SELECT parent_flex_value_set_id
213: FROM fnd_flex_value_sets
214: WHERE flex_value_set_id = p_flex_value_set_id
215: );
216:
217: /* end of changes for bug:7641746 */