369: SELECT select_id
370: , select_name
371: , from_table
372: , where_clause
373: FROM jtf_objects_vl
374: WHERE object_code = p_object_type_code;
375: l_rec c_ref%ROWTYPE;
376: -- max data from jtf_objects_vl can be about 2600
377: l_stmt VARCHAR2(3000);
372: , where_clause
373: FROM jtf_objects_vl
374: WHERE object_code = p_object_type_code;
375: l_rec c_ref%ROWTYPE;
376: -- max data from jtf_objects_vl can be about 2600
377: l_stmt VARCHAR2(3000);
378: -- highest max col length found in dom1151 = 421
379: l_name VARCHAR2(500) := NULL;
380: BEGIN