610:
611: CURSOR c_qualifier
612: IS
613: SELECT 'x'
614: FROM fnd_segment_attribute_values
615: WHERE application_id = p_application_id
616: AND id_flex_code = p_flex_code
617: AND id_flex_num = p_chart_of_accounts_id
618: AND segment_attribute_type = p_flexfield_segment_code
829:
830: CURSOR c_segment
831: IS
832: SELECT application_column_name
833: FROM fnd_segment_attribute_values
834: WHERE application_id = p_application_id
835: AND id_flex_code = p_id_flex_code
836: AND id_flex_num = p_id_flex_num
837: AND segment_attribute_type = p_qualifier_segment
891:
892: CURSOR c_qualifier
893: IS
894: SELECT segment_attribute_type
895: FROM fnd_segment_attribute_values
896: WHERE application_id = p_application_id
897: AND id_flex_code = p_id_flex_code
898: AND id_flex_num = p_id_flex_num
899: AND application_column_name = p_segment_code