99:
100: CURSOR c_segment_info
101: IS
102: SELECT UPPER(application_column_name) application_column_name
103: FROM fnd_id_flex_segments
104: WHERE application_id = 101
105: AND id_flex_code = 'GL#'
106: AND id_flex_num = v_ca_id
107: ORDER BY segment_num;
323: BEGIN
324: v_statement := 'L';
325: SELECT flex_value_set_id
326: INTO v_flex_value_id
327: FROM fnd_id_flex_segments_vl
328: WHERE id_flex_num = v_ca_id
329: AND application_id = 101
330: AND id_flex_code = 'GL#'
331: AND application_column_name = v_acct_seg_name;