APPS.AME_RULE_UTILITY_PKG dependencies on AME_APPROVAL_GROUP_CONFIG

Line 274: from ame_approval_group_config agf

270: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
271: and to_char(apg.approval_group_id) = act.parameter
272: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate)
273: and not exists (select null
274: from ame_approval_group_config agf
275: where agf.application_id = applicationIdIn
276: and agf.approval_group_id = apg.approval_group_id
277: and sysdate between agf.start_date and nvl(agf.end_date - (1/86400), sysdate))
278: and aty.name in ('pre-chain-of-authority approvals'

Line 634: from ame_approval_group_config agf

630: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)
631: and to_char(apg.approval_group_id) = act.parameter
632: and sysdate between apg.start_date and nvl(apg.end_date - (1/86400), sysdate)
633: and not exists (select null
634: from ame_approval_group_config agf
635: where agf.application_id = applicationIdIn
636: and agf.approval_group_id = apg.approval_group_id
637: and sysdate between agf.start_date and nvl(agf.end_date - (1/86400), sysdate))
638: and aty.name in ('pre-chain-of-authority approvals'

Line 1245: from ame_approval_group_config agf

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
1245: from ame_approval_group_config agf
1246: where agf.application_id = applicationIdIn
1247: and sysdate between agf.start_date
1248: and nvl(agf.end_date - (1/86400), sysdate))
1249: and aty.name in (ame_util.preApprovalTypeName

Line 2150: from ame_approval_group_config gpc

2146: --+
2147: cursor get_groups(p_application_id in integer
2148: ,p_approval_group_id in integer) is
2149: select count(*)
2150: from ame_approval_group_config gpc
2151: where gpc.approval_group_id = p_approval_group_id
2152: and gpc.application_id = p_application_id
2153: and sysdate between gpc.start_date and nvl(gpc.end_date - (1/86400),sysdate);
2154: --+