256: from ame_action_types aty
257: ,ame_actions act
258: ,ame_action_usages acu
259: ,ame_rules rul
260: ,ame_approval_groups apg
261: where rul.rule_id = ruleIdIn
262: and rul.end_date = endDateIn
263: and rul.start_date < endDateIn
264: and rul.rule_id = acu.rule_id
612: from ame_action_types aty
613: ,ame_actions act
614: ,ame_action_usages acu
615: ,ame_rules rul
616: ,ame_approval_groups apg
617: where rul.rule_id = ruleIdIn
618: and ((sysdate between rul.start_date and nvl(rul.end_date - (1/86400),sysdate))
619: or
620: (sysdate < rul.start_date and rul.start_date < nvl(rul.end_date, rul.start_date + (1/86400)))
1236: ,actionIdIn in integer) is
1237: select apg.approval_group_id, apg.name
1238: from ame_action_types aty
1239: ,ame_actions act
1240: ,ame_approval_groups apg
1241: where act.action_id = actionIdIn
1242: and act.action_type_id = aty.action_type_id
1243: and act.parameter = to_char(apg.approval_group_id)
1244: and apg.approval_group_id not in (select agf.approval_group_id