DBA Data[Home] [Help]

APPS.AME_TEST_UTILITY_PKG dependencies on AME_RULES_VL

Line 351: ruleDesc ame_rules_vl.description%type;

347: return null;
348: end getActionsList;
349: --+
350: function getRuleDescription(ruleIdIn in integer,effectiveRuleDate in date) return varchar2 as
351: ruleDesc ame_rules_vl.description%type;
352: begin
353: select description
354: into ruleDesc
355: from ame_rules_vl

Line 355: from ame_rules_vl

351: ruleDesc ame_rules_vl.description%type;
352: begin
353: select description
354: into ruleDesc
355: from ame_rules_vl
356: where rule_id = ruleIdIn
357: and effectiveRuleDate between start_date
358: and nvl(end_date - ame_util.oneSecond, sysdate);
359: return ruleDesc;