[Home] [Help]
207: select '1'
208: into l_exists
209: from dual
210: where exists (select distinct object_counter_id
211: from csi_counter_relationships
212: where source_counter_id = p_src_counter_id
213: and relationship_type_code = 'FORMULA'
214: and nvl(active_end_date,(sysdate+1)) > sysdate
215: AND ROWNUM = 1);