APPS.OKL_CURE_VNDR_RFND_PVT dependencies on OKL_CURE_REFUND_HEADERS_B

Line 35: from OKL_CURE_REFUND_HEADERS_B

31: l_obj_vers_no NUMBER;
32:
33: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is
34: select object_version_number
35: from OKL_CURE_REFUND_HEADERS_B
36: where cure_refund_header_id = l_cure_refund_header_id;
37:
38: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
39: select sum(received_amount),sum(offset_amount), sum(disbursement_amount)

Line 235: from OKL_CURE_REFUND_HEADERS_B

231: l_tot_disbursement_amount okl_cure_refunds.disbursement_amount%type := 0;
232:
233: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is
234: select object_version_number
235: from OKL_CURE_REFUND_HEADERS_B
236: where cure_refund_header_id = l_cure_refund_header_id;
237:
238: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
239: select sum(received_amount),sum(offset_amount), sum(disbursement_amount)

Line 436: from OKL_CURE_REFUND_HEADERS_B

432: l_obj_vers_no NUMBER;
433:
434: Cursor get_obj_vers_no(l_cure_refund_header_id NUMBER) is
435: select object_version_number
436: from OKL_CURE_REFUND_HEADERS_B
437: where cure_refund_header_id = l_cure_refund_header_id;
438:
439: Cursor get_hdr_amounts_csr(l_cure_refund_header_id NUMBER) is
440: select sum(received_amount),sum(offset_amount)