197: BEGIN
198: Begin
199: select 'x'
200: into l_exists
201: from CSI_LOOKUPS
202: where lookup_type = l_adj_type
203: and lookup_code = p_adjustment_type;
204: l_return_value := TRUE;
205: Exception
218: BEGIN
219: Begin
220: select 'x'
221: into l_exists
222: from CSI_LOOKUPS
223: where lookup_type = l_adj_type
224: and lookup_code = p_reset_mode;
225: l_return_value := TRUE;
226: Exception
5234: l_process_flag BOOLEAN := TRUE;
5235: --
5236: CURSOR PROP_LOV_CUR(p_prop_id IN NUMBER) IS
5237: select lookup_code,meaning --Meaning added for bug #6904836
5238: from CSI_LOOKUPS
5239: where lookup_type = (select property_lov_type
5240: from CSI_COUNTER_PROPERTIES_B
5241: where counter_property_id = p_prop_id);
5242: BEGIN