5416: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
5417: SELECT display_order
5418: FROM (SELECT ROWNUM display_order, application_column_name
5419: FROM ( SELECT application_column_name
5420: FROM FND_ID_FLEX_SEGMENTS_VL
5421: WHERE ID_FLEX_NUM = p_coa_id
5422: AND ID_FLEX_CODE = 'GL#'
5423: AND APPLICATION_ID = 101
5424: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))
6131: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
6132: SELECT display_order
6133: FROM (SELECT ROWNUM display_order, application_column_name
6134: FROM ( SELECT application_column_name
6135: FROM FND_ID_FLEX_SEGMENTS_VL
6136: WHERE ID_FLEX_NUM = p_coa_id
6137: AND ID_FLEX_CODE = 'GL#'
6138: AND APPLICATION_ID = 101
6139: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))
7485: CURSOR c_seg_number (p_seg_col_name VARCHAR2, p_coa_id INTEGER) IS
7486: SELECT display_order
7487: FROM (SELECT ROWNUM display_order, application_column_name
7488: FROM ( SELECT application_column_name
7489: FROM FND_ID_FLEX_SEGMENTS_VL
7490: WHERE ID_FLEX_NUM = p_coa_id
7491: AND ID_FLEX_CODE = 'GL#'
7492: AND APPLICATION_ID = 101
7493: order by decode(enabled_flag, 'Y', 1, 'N', 2), segment_num))