292: l_rule_type number;
293: begin
294: SELECT rule_type
295: INTO l_rule_type
296: FROM ame_action_type_usages
297: WHERE action_type_id = p_action_type_id
298: AND SYSDATE BETWEEN start_date and
299: nvl(end_date - (1/86400), sysdate)
300: AND ROWNUM < 2;
359: l_rule_type number;
360: begin
361: SELECT rule_type
362: INTO l_rule_type
363: FROM ame_action_type_usages
364: WHERE action_type_id = p_action_type_id
365: AND SYSDATE BETWEEN start_date and
366: nvl(end_date - (1/86400), sysdate)
367: AND ROWNUM < 2;