APPS.AME_CNU_BUS dependencies on AME_UTIL

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

49: from ame_conditions
50: where
51: condition_id = p_condition_id and
52: p_effective_date between start_date and
53: nvl(end_date - ame_util.oneSecond, p_effective_date) ;
54: l_exists varchar2(1);
55: begin
56: open c_sel1;
57: fetch c_sel1 into l_exists;

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

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

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

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