1688: begin
1689:
1690: select object_code, select_id, from_table, where_clause
1691: into l_ref_object_value, x_select_id, x_from_table, x_where_clause 1692: from jtf_objects_b 1693: where sysdate between nvl(start_date_active, sysdate) and nvl(end_date_active, sysdate)
1694: and object_code = l_ref_object_code;
1695:
1696: if l_ref_object_value is null then x_object_count :=0; else x_object_count :=1; end if;