APPS.AME_ACU_BUS dependencies on AME_UTIL

Line 51: nvl(end_date - ame_util.oneSecond, p_effective_date) ;

47: from ame_actions
48: where
49: action_id = p_action_id and
50: p_effective_date between start_date and
51: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
52: l_exists varchar2(1);
53: begin
54: open c_sel1;
55: fetch c_sel1 into l_exists;

Line 112: nvl(end_date - ame_util.oneSecond, p_effective_date)) or

108: from ame_rules
109: where
110: rule_id = p_rule_id and
111: ((p_effective_date between start_date and
112: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
113: (p_effective_date < start_date and
114: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
115: l_exists varchar2(1);
116: begin

Line 114: start_date < nvl(end_date,start_date + ame_util.oneSecond)));

110: rule_id = p_rule_id and
111: ((p_effective_date between start_date and
112: nvl(end_date - ame_util.oneSecond, p_effective_date)) or
113: (p_effective_date < start_date and
114: start_date < nvl(end_date,start_date + ame_util.oneSecond)));
115: l_exists varchar2(1);
116: begin
117: open c_sel1;
118: fetch c_sel1 into l_exists;