727:
728: cursor get_qualifiers(p_f_code varchar2, p_f_num number, p_col_name varchar2) is
729: select segment_prompt
730: from fnd_segment_attribute_values sav,
731: fnd_segment_attribute_types sat
732: where sav.attribute_value = 'Y'
733: and sav.segment_attribute_type <> 'GL_GLOBAL'
734: and sav.application_id = sat.application_id
735: and sav.id_flex_code = sat.id_flex_code
2931:
2932: cursor get_qualifiers(p_f_code varchar2, p_f_num number, p_col_name varchar2) is
2933: select segment_prompt
2934: from fnd_segment_attribute_values sav,
2935: fnd_segment_attribute_types sat
2936: where sav.attribute_value = 'Y'
2937: and sav.segment_attribute_type <> 'GL_GLOBAL'
2938: and sav.application_id = sat.application_id
2939: and sav.id_flex_code = sat.id_flex_code