152: -- has usage for this transaction type
153: --
154: cursor C_Sel1 is
155: select count(*) 156: from ame_action_types aty 157: ,ame_actions act
158: ,ame_rule_usages aru
159: ,ame_action_usages actu
160: where aty.name in ( ame_util.preApprovalTypeName