eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AME_RULE_UTILITY_PKG dependencies on AME_ACTION_TYPE_CONFIG

Line 242: from ame_action_type_config atf

238: and rul.rule_id = acu.rule_id
239: and acu.action_id = act.action_id
240: and act.action_type_id = aty.action_type_id
241: and aty.action_type_id not in (select atf.action_type_id
242: from ame_action_type_config atf
243: where atf.application_id = applicationIdIn
244: and sysdate between atf.start_date
245: and nvl(atf.end_date - (1/86400), sysdate))
246: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)

Line 594: from ame_action_type_config atf

590: and rul.rule_id = acu.rule_id
591: and acu.action_id = act.action_id
592: and act.action_type_id = aty.action_type_id
593: and aty.action_type_id not in (select atf.action_type_id
594: from ame_action_type_config atf
595: where atf.application_id = applicationIdIn
596: and sysdate between atf.start_date
597: and nvl(atf.end_date - (1/86400), sysdate))
598: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)

Line 1210: from ame_action_type_config atf

1206: ,ame_actions act
1207: where act.action_id = actionIdIn
1208: and act.action_type_id = aty.action_type_id
1209: and aty.action_type_id not in (select atf.action_type_id
1210: from ame_action_type_config atf
1211: where atf.application_id = applicationIdIn
1212: and sysdate between atf.start_date
1213: and nvl(atf.end_date - (1/86400), sysdate))
1214: and sysdate between aty.start_date and nvl(aty.end_date - (1/86400), sysdate)

Line 1650: ,ame_action_type_config atf

1646: cursor getActions(p_application_id in integer
1647: ,p_action_id in integer) is
1648: select count(act.action_id)
1649: from ame_actions act
1650: ,ame_action_type_config atf
1651: ,ame_action_types aty
1652: where act.action_id = p_action_id
1653: and atf.application_id = p_application_id
1654: and act.action_type_id = atf.action_type_id

Line 1667: ,ame_action_type_config atf

1663: cursor getPosActions(p_application_id in integer
1664: ,p_action_id in integer) is
1665: select count(*)
1666: from ame_actions act
1667: ,ame_action_type_config atf
1668: ,ame_action_types aty
1669: where act.action_id = p_action_id
1670: and atf.application_id = p_application_id
1671: and act.action_type_id = atf.action_type_id

Line 1683: ,ame_action_type_config atf

1679: cursor getGroupActions(p_application_id in integer
1680: ,p_action_id in integer) is
1681: select act.parameter
1682: from ame_actions act
1683: ,ame_action_type_config atf
1684: ,ame_action_types aty
1685: where act.action_id = p_action_id
1686: and atf.application_id = p_application_id
1687: and act.action_type_id = atf.action_type_id