APPS.CE_INTEREST_SCHED_PKG dependencies on CE_INTEREST_RATES

Line 272: | CE_INTEREST_RATES |

268: | InterestAMImpl (populateIntRate) |
269: | delete_schedule |
270: | DESCRIPTION |
271: | delete interest_rates from
272: | CE_INTEREST_RATES |
273: --------------------------------------------------------------------- */
274: PROCEDURE delete_interest_rates(p_interest_schedule_id number,
275: p_effective_date date) IS
276:

Line 287: from CE_INTEREST_RATES

283:
284: IF (p_effective_date is not null) THEN
285: select count(*)
286: into x_interest_rate_count
287: from CE_INTEREST_RATES
288: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES
289: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id)
290: and EFFECTIVE_DATE = p_effective_date;
291:

Line 301: DELETE FROM CE_INTEREST_RATES

297: fnd_msg_pub.add;
298: END IF;
299: END IF;
300: IF (p_interest_schedule_id is not null and p_effective_date is not null) THEN
301: DELETE FROM CE_INTEREST_RATES
302: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES
303: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id)
304: and EFFECTIVE_DATE = p_effective_date;
305:

Line 307: DELETE FROM CE_INTEREST_RATES

303: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id)
304: and EFFECTIVE_DATE = p_effective_date;
305:
306: ELSIF (p_interest_schedule_id is not null and p_effective_date is null) THEN
307: DELETE FROM CE_INTEREST_RATES
308: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES
309: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id);
310:
311: END IF;