APPS.AME_RULE_UTILITY_PKG dependencies on AME_RULE_USAGES

Line 480: from ame_rule_usages

476: --+
477: cursor checkRuleCursor(ruleIdIn in integer
478: ,applicationIdIn in integer) is
479: select 'Y'
480: from ame_rule_usages
481: where rule_id = ruleIdIn
482: and item_id = applicationIdIn
483: and ((sysdate between start_date and nvl(end_date - (1/86400),sysdate))
484: or

Line 1105: from ame_rule_usages rlu

1101: ,conditionIdIn in integer) is
1102: --+
1103: cursor getApplications is
1104: select aca.application_id, aca.application_name
1105: from ame_rule_usages rlu
1106: ,ame_calling_apps aca
1107: where rlu.rule_id = ruleIdIn
1108: and aca.application_id = rlu.item_id
1109: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)

Line 1192: from ame_rule_usages rlu

1188: ,actionIdIn in integer) is
1189: --+
1190: cursor getApplications is
1191: select aca.application_id, aca.application_name
1192: from ame_rule_usages rlu
1193: ,ame_calling_apps aca
1194: where rlu.rule_id = ruleIdIn
1195: and aca.application_id = rlu.item_id
1196: and sysdate between aca.start_date and nvl(aca.end_date - (1/86400), sysdate)

Line 1342: from ame_rule_usages

1338: ,p_rul_end_date out nocopy date) as
1339: begin
1340: select min(start_date)
1341: into p_rul_start_date
1342: from ame_rule_usages
1343: where rule_id = p_rule_id
1344: and (sysdate between start_date
1345: and nvl(end_date - ame_util.oneSecond, sysdate )
1346: or

Line 1351: from ame_rule_usages

1347: (sysdate < start_date
1348: and start_date < nvl(end_date, start_date + ame_util.oneSecond)));
1349: select max(end_date)
1350: into p_rul_end_date
1351: from ame_rule_usages
1352: where rule_id = p_rule_id
1353: and (sysdate between start_date
1354: and nvl(end_date - ame_util.oneSecond, sysdate )
1355: or