4657:
4658: CURSOR c_references(l_object_type_code varchar2)
4659: IS
4660: SELECT select_id, select_name, from_table, where_clause
4661: FROM jtf_objects_b
4662: WHERE object_code = l_object_type_code;
4663:
4664: l_id_column jtf_objects_b.select_id%TYPE;
4665: l_name_column jtf_objects_b.select_name%TYPE;
4660: SELECT select_id, select_name, from_table, where_clause
4661: FROM jtf_objects_b
4662: WHERE object_code = l_object_type_code;
4663:
4664: l_id_column jtf_objects_b.select_id%TYPE;
4665: l_name_column jtf_objects_b.select_name%TYPE;
4666: l_from_clause jtf_objects_b.from_table%TYPE;
4667: l_where_clause jtf_objects_b.where_clause%TYPE;
4668: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4661: FROM jtf_objects_b
4662: WHERE object_code = l_object_type_code;
4663:
4664: l_id_column jtf_objects_b.select_id%TYPE;
4665: l_name_column jtf_objects_b.select_name%TYPE;
4666: l_from_clause jtf_objects_b.from_table%TYPE;
4667: l_where_clause jtf_objects_b.where_clause%TYPE;
4668: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4669: := p_object_type_code;
4662: WHERE object_code = l_object_type_code;
4663:
4664: l_id_column jtf_objects_b.select_id%TYPE;
4665: l_name_column jtf_objects_b.select_name%TYPE;
4666: l_from_clause jtf_objects_b.from_table%TYPE;
4667: l_where_clause jtf_objects_b.where_clause%TYPE;
4668: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4669: := p_object_type_code;
4670: l_object_name jtf_tasks_b.source_object_name%TYPE;
4663:
4664: l_id_column jtf_objects_b.select_id%TYPE;
4665: l_name_column jtf_objects_b.select_name%TYPE;
4666: l_from_clause jtf_objects_b.from_table%TYPE;
4667: l_where_clause jtf_objects_b.where_clause%TYPE;
4668: l_object_code jtf_tasks_b.source_object_type_code%TYPE
4669: := p_object_type_code;
4670: l_object_name jtf_tasks_b.source_object_name%TYPE;
4671: l_object_id jtf_tasks_b.source_object_id%TYPE