1778: begin
1779:
1780: select object_code, select_id, from_table, where_clause
1781: into l_ref_object_value, x_select_id, x_from_table, x_where_clause 1782: from jtf_objects_b 1783: where sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
1784: and object_code = l_ref_object_code;
1785:
1786: if l_ref_object_value is null then x_object_count :=0; else x_object_count :=1; end if;