APPS.AME_UTILITY_PKG dependencies on AME_RULE_USAGES

Line 992: from ame_rule_usages aru

988: null CONDITION_USAGE_LUD,
989: null CONDITION_USAGE_LUB,
990: null ACTION_USAGE_LUD,
991: null ACTION_USAGE_LUB
992: from ame_rule_usages aru
993: where aru.rule_id = c_rule_id
994: and aru.item_id = c_application_id
995: and aru.start_date = c_rule_usage_start_date
996: and aru.start_date < aru.end_date

Line 998: from ame_rule_usages arut

994: and aru.item_id = c_application_id
995: and aru.start_date = c_rule_usage_start_date
996: and aru.start_date < aru.end_date
997: and aru.last_update_date in (select max(last_update_date)
998: from ame_rule_usages arut
999: where arut.rule_id = c_rule_id
1000: and arut.item_id = c_application_id
1001: and arut.start_date = c_rule_usage_start_date
1002: and arut.start_date < arut.end_date)

Line 1149: from ame_rule_usages aru

1145: null CONDITION_USAGE_LUD,
1146: null CONDITION_USAGE_LUB,
1147: null ACTION_USAGE_LUD,
1148: null ACTION_USAGE_LUB
1149: from ame_rule_usages aru
1150: where aru.rule_id = c_rule_id
1151: and aru.item_id = c_application_id
1152: and aru.start_date = c_rule_usage_start_date
1153: and aru.start_date < aru.end_date

Line 1155: from ame_rule_usages arut

1151: and aru.item_id = c_application_id
1152: and aru.start_date = c_rule_usage_start_date
1153: and aru.start_date < aru.end_date
1154: and aru.last_update_date in (select max(last_update_date)
1155: from ame_rule_usages arut
1156: where arut.rule_id = c_rule_id
1157: and arut.item_id = c_application_id
1158: and arut.start_date = c_rule_usage_start_date
1159: and arut.start_date < arut.end_date)

Line 1290: from ame_rule_usages

1286: );
1287:
1288: cursor active_rule_usage_count_cursor (ruleId integer,applicationId integer,usageStartDate date) is
1289: select count(rule_id)
1290: from ame_rule_usages
1291: where rule_id = ruleId
1292: and item_id = applicationId
1293: and start_date = usageStartDate
1294: and start_date < end_date