228: return grade_record is
229:
230: cursor bne_cols(c_interface_code in varchar2) is
231: select lower(bic.interface_col_name) interface_col_name
232: from bne_interface_cols_b bic
233: where bic.interface_code = c_interface_code
234: and bic.display_flag ='Y';
235:
236: -- To query cols which are not displayed (DFF segments)
235:
236: -- To query cols which are not displayed (DFF segments)
237: cursor bne_cols_no_disp(c_interface_code in varchar2) is
238: select lower(bic.interface_col_name) interface_col_name
239: from bne_interface_cols_b bic
240: where bic.interface_code = c_interface_code
241: and bic.display_flag ='N';
242:
243: l_grade_rec grade_record;