385: cursor csr_in_use_by_rule_usages is
386: select count(*)
387: from
388: ame_rule_usages rlu, 389: ame_rules rl 390: where rlu.rule_id = rl.rule_id
391: and rlu.item_id = p_application_id
392: and rl.item_class_id = p_item_class_id
393: and ((p_start_date between rl.start_date and nvl(rl.end_date - ame_util.oneSecond, p_start_date)) or
[Home] [Help]