APPS.AME_UTILITY_PKG dependencies on AME_CONDITION_USAGES

Line 1014: from ame_condition_usages acu

1010: acu.last_update_date CONDITION_USAGE_LUD,
1011: acu.last_updated_by CONDITION_USAGE_LUB,
1012: null ACTION_USAGE_LUD,
1013: null ACTION_USAGE_LUB
1014: from ame_condition_usages acu
1015: where acu.rule_id = c_rule_id
1016: and acu.last_update_date in (select max(last_update_date)
1017: from ame_condition_usages acut
1018: where acut.rule_id = c_rule_id)

Line 1017: from ame_condition_usages acut

1013: null ACTION_USAGE_LUB
1014: from ame_condition_usages acu
1015: where acu.rule_id = c_rule_id
1016: and acu.last_update_date in (select max(last_update_date)
1017: from ame_condition_usages acut
1018: where acut.rule_id = c_rule_id)
1019: and rownum < 2
1020: union
1021: select null RULE_LUD,

Line 1171: from ame_condition_usages acu

1167: acu.last_update_date CONDITION_USAGE_LUD,
1168: acu.last_updated_by CONDITION_USAGE_LUB,
1169: null ACTION_USAGE_LUD,
1170: null ACTION_USAGE_LUB
1171: from ame_condition_usages acu
1172: where acu.rule_id = c_rule_id
1173: and acu.last_update_date in (select max(last_update_date)
1174: from ame_condition_usages acut
1175: where acut.rule_id = c_rule_id)

Line 1174: from ame_condition_usages acut

1170: null ACTION_USAGE_LUB
1171: from ame_condition_usages acu
1172: where acu.rule_id = c_rule_id
1173: and acu.last_update_date in (select max(last_update_date)
1174: from ame_condition_usages acut
1175: where acut.rule_id = c_rule_id)
1176: and rownum < 2
1177: union
1178: select null RULE_LUD,

Line 1341: from ame_condition_usages acu

1337: union
1338: select null RULE_COUNT,
1339: count(acu.rule_id) CONDITION_USAGE_COUNT,
1340: null ACTION_USAGE_COUNT
1341: from ame_condition_usages acu
1342: where acu.rule_id = c_rule_id
1343: and acu.last_update_date > (c_rule_usage_start_date + (1/86400))
1344: union
1345: select null RULE_COUNT,