APPS.AR_INTEREST_BATCHES_PKG dependencies on AR_INTEREST_LINES

Line 16: FROM ar_interest_lines iil,

12: RETURN NUMBER
13: IS
14: CURSOR c IS
15: SELECT SUM(NVL(iil.INTEREST_CHARGED,0))
16: FROM ar_interest_lines iil,
17: ar_interest_headers ii,
18: ar_interest_batches ib
19: WHERE iil.interest_header_id = ii.interest_header_id
20: AND ib.interest_batch_id = ii.interest_batch_id

Line 312: DELETE FROM ar_interest_lines iil

308: IF x_return_status <> fnd_api.g_ret_sts_success THEN
309: RAISE fnd_api.g_exc_error;
310: END IF;
311:
312: DELETE FROM ar_interest_lines iil
313: WHERE EXISTS
314: (SELECT interest_header_id
315: FROM ar_interest_headers ii
316: WHERE iil.interest_header_id = ii.interest_header_id

Line 447: UPDATE ar_interest_lines iil

443: x_OBJECT_VERSION_NUMBER := NVL(x_OBJECT_VERSION_NUMBER,1) + 1;
444:
445: IF x_cascade_update = 'Y' THEN
446:
447: UPDATE ar_interest_lines iil
448: SET process_status = 'N',
449: object_version_number = NVL(object_version_number,1) + 1
450: WHERE EXISTS
451: (SELECT interest_header_id