DBA Data[Home] [Help]

APPS.AR_INTEREST_HEADERS_PKG dependencies on AR_INTEREST_LINES

Line 17: FROM ar_interest_lines iil,

13: RETURN NUMBER
14: IS
15: CURSOR c IS
16: SELECT SUM(NVL(iil.INTEREST_CHARGED,0))
17: FROM ar_interest_lines iil,
18: ar_interest_headers ii
19: WHERE ii.interest_header_id = iil.interest_header_id
20: AND ii.interest_header_id = p_interest_header_id;
21: l_header_amount number;

Line 403: DELETE FROM ar_interest_lines

399: IF x_return_status <> fnd_api.g_ret_sts_success THEN
400: RAISE fnd_api.g_exc_error;
401: END IF;
402:
403: DELETE FROM ar_interest_lines
404: WHERE interest_header_id = p_interest_header_id;
405:
406: DELETE FROM AR_INTEREST_HEADERS
407: WHERE interest_header_id = p_interest_header_id;