DBA Data[Home] [Help]

APPS.XLA_REPORT_UTILITY_PKG dependencies on FND_FLEX_VALUE_SETS

Line 201: from fnd_flex_value_sets

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

Line 213: FROM fnd_flex_value_sets

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 */