DBA Data[Home] [Help]

APPS.AME_RULE_UTILITY_PKG dependencies on AME_APPROVAL_GROUPS

Line 260: ,ame_approval_groups apg

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

Line 616: ,ame_approval_groups apg

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)))

Line 1240: ,ame_approval_groups apg

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