139: ,ameApplicationIdIn in number) is
140: select 'Y'
141: from ame_actions act,
142: ame_action_usages acu, 143: ame_rule_usages aru 144: where acu.rule_id = aru.rule_id
145: and act.action_id = acu.action_id
146: and act.parameter = groupIdIn
147: and aru.item_id = ameApplicationIdIn