775: RETURN VARCHAR2
776: IS
777: CURSOR c_object IS
778: SELECT select_id, select_details, from_table, where_clause
779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
778: SELECT select_id, select_details, from_table, where_clause
779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
779: FROM jtf_objects_b
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);
780: WHERE object_code = p_object_code;
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);
788: sql_stmt VARCHAR2(2000);
781:
782: l_id_column jtf_objects_b.select_id%TYPE;
783: l_detail_column jtf_objects_b.select_details%TYPE;
784: l_from_clause jtf_objects_b.from_table%TYPE;
785: l_where_clause jtf_objects_b.where_clause%TYPE;
786:
787: l_object_details VARCHAR2(2000);
788: sql_stmt VARCHAR2(2000);
789: BEGIN