APPS.CE_INTEREST_SCHED_PKG dependencies on CE_INTEREST_BAL_RANGES

Line 288: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES

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:
292: -- make sure at least one transaction exist

Line 302: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES

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:
306: ELSIF (p_interest_schedule_id is not null and p_effective_date is null) THEN

Line 308: WHERE BALANCE_RANGE_ID in (SELECT BALANCE_RANGE_ID FROM CE_INTEREST_BAL_RANGES

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;
312:

Line 345: DELETE FROM CE_INTEREST_BAL_RANGES

341: cep_standard.debug('>> CE_INTEREST_SCHED_PKG.delete_bal_ranges');
342: END IF;
343:
344: IF (p_interest_schedule_id is not null) THEN
345: DELETE FROM CE_INTEREST_BAL_RANGES
346: WHERE INTEREST_SCHEDULE_ID = p_interest_schedule_id;
347:
348: END IF;
349: