4923:
4924: CURSOR c_references(l_object_type_code varchar2)
4925: IS
4926: SELECT select_id, select_name, from_table, where_clause
4927: FROM jtf_objects_b
4928: WHERE object_code = l_object_type_code;
4929:
4930: l_id_column jtf_objects_b.select_id%TYPE;
4931: l_name_column jtf_objects_b.select_name%TYPE;
4926: SELECT select_id, select_name, from_table, where_clause
4927: FROM jtf_objects_b
4928: WHERE object_code = l_object_type_code;
4929:
4930: l_id_column jtf_objects_b.select_id%TYPE;
4931: l_name_column jtf_objects_b.select_name%TYPE;
4932: l_from_clause jtf_objects_b.from_table%TYPE;
4933: l_where_clause jtf_objects_b.where_clause%TYPE;
4934: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4927: FROM jtf_objects_b
4928: WHERE object_code = l_object_type_code;
4929:
4930: l_id_column jtf_objects_b.select_id%TYPE;
4931: l_name_column jtf_objects_b.select_name%TYPE;
4932: l_from_clause jtf_objects_b.from_table%TYPE;
4933: l_where_clause jtf_objects_b.where_clause%TYPE;
4934: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4935: := p_object_type_code;
4928: WHERE object_code = l_object_type_code;
4929:
4930: l_id_column jtf_objects_b.select_id%TYPE;
4931: l_name_column jtf_objects_b.select_name%TYPE;
4932: l_from_clause jtf_objects_b.from_table%TYPE;
4933: l_where_clause jtf_objects_b.where_clause%TYPE;
4934: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4935: := p_object_type_code;
4936: l_object_name jtf_tasks_b.source_object_name%TYPE;
4929:
4930: l_id_column jtf_objects_b.select_id%TYPE;
4931: l_name_column jtf_objects_b.select_name%TYPE;
4932: l_from_clause jtf_objects_b.from_table%TYPE;
4933: l_where_clause jtf_objects_b.where_clause%TYPE;
4934: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4935: := p_object_type_code;
4936: l_object_name jtf_tasks_b.source_object_name%TYPE;
4937: l_object_id jtf_tasks_b.source_object_id%TYPE