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_PKG dependencies on AME_CALLING_APPS

Line 4190: ame_calling_apps

4186: cursor getAppUsagesCursor(ruleIdIn in integer) is
4187: select application_id,
4188: application_name
4189: from ame_rule_usages,
4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and

Line 4192: ame_rule_usages.item_id = ame_calling_apps.application_id and

4188: application_name
4189: from ame_rule_usages,
4190: ame_calling_apps
4191: where
4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and

Line 4196: (ame_calling_apps.start_date <= sysdate and

4192: ame_rule_usages.item_id = ame_calling_apps.application_id and
4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and
4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))
4198: order by application_name;
4199: tempIndex integer;
4200: begin

Line 4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))

4193: ame_rule_usages.rule_id = ruleIdIn and
4194: (ame_rule_usages.start_date <= sysdate and
4195: (ame_rule_usages.end_date is null or sysdate < ame_rule_usages.end_date)) and
4196: (ame_calling_apps.start_date <= sysdate and
4197: (ame_calling_apps.end_date is null or sysdate < ame_calling_apps.end_date))
4198: order by application_name;
4199: tempIndex integer;
4200: begin
4201: tempIndex := 1;

Line 4761: from ame_calling_apps

4757: /* This procedure updates the rule's stripe set in each transaction type that uses striping. */
4758: /*
4759: cursor applicationIdCursor is
4760: select application_id
4761: from ame_calling_apps
4762: where
4763: start_date <= sysdate and
4764: (end_date is null or sysdate < end_date);
4765: applicationIds ame_util.idList;