APPS.AME_UTILITY_PKG dependencies on AME_ACTION_USAGES

Line 1030: from ame_action_usages aau

1026: null CONDITION_USAGE_LUD,
1027: null CONDITION_USAGE_LUB,
1028: aau.last_update_date ACTION_USAGE_LUD,
1029: aau.last_updated_by ACTION_USAGE_LUB
1030: from ame_action_usages aau
1031: where aau.rule_id = c_rule_id
1032: and aau.last_update_date in (select max(last_update_date)
1033: from ame_action_usages aaut
1034: where aaut.rule_id = c_rule_id)

Line 1033: from ame_action_usages aaut

1029: aau.last_updated_by ACTION_USAGE_LUB
1030: from ame_action_usages aau
1031: where aau.rule_id = c_rule_id
1032: and aau.last_update_date in (select max(last_update_date)
1033: from ame_action_usages aaut
1034: where aaut.rule_id = c_rule_id)
1035: and rownum < 2;
1036:
1037: rl_lud date;

Line 1187: from ame_action_usages aau

1183: null CONDITION_USAGE_LUD,
1184: null CONDITION_USAGE_LUB,
1185: aau.last_update_date ACTION_USAGE_LUD,
1186: aau.last_updated_by ACTION_USAGE_LUB
1187: from ame_action_usages aau
1188: where aau.rule_id = c_rule_id
1189: and aau.last_update_date in (select max(last_update_date)
1190: from ame_action_usages aaut
1191: where aaut.rule_id = c_rule_id)

Line 1190: from ame_action_usages aaut

1186: aau.last_updated_by ACTION_USAGE_LUB
1187: from ame_action_usages aau
1188: where aau.rule_id = c_rule_id
1189: and aau.last_update_date in (select max(last_update_date)
1190: from ame_action_usages aaut
1191: where aaut.rule_id = c_rule_id)
1192: and rownum < 2;
1193:
1194: rl_lud date;

Line 1348: from ame_action_usages aau

1344: union
1345: select null RULE_COUNT,
1346: null CONDITION_USAGE_COUNT,
1347: count(aau.rule_id) ACTION_USAGE_COUNT
1348: from ame_action_usages aau
1349: where aau.rule_id = c_rule_id
1350: and aau.last_update_date > (c_rule_usage_start_date + (1/86400));
1351: rl_cnt integer;
1352: cu_cnt integer;