APPS.OKL_COMMON_FUNCTIONS dependencies on OKL_CURE_PAYMENT_LINES

Line 16: FROM OKL_cure_payment_lines

12:
13: -- Get unrefunded cures for a contract
14: /*CURSOR unrefunded_cures_csr(p_contract_id NUMBER) IS
15: SELECT SUM(amount)
16: FROM OKL_cure_payment_lines
17: WHERE chr_id = p_contract_id
18: AND status = 'CURES_IN_POSSESSION'; */
19:
20: l_unrefunded_cures NUMBER := 0;

Line 55: FROM OKL_CURE_PAYMENT_LINES

51: FUNCTION get_cured_status (p_contract_number IN NUMBER)
52: RETURN VARCHAR2 IS
53: CURSOR c_cured (p_chr_id NUMBER) is
54: SELECT 'Y'
55: FROM OKL_CURE_PAYMENT_LINES
56: WHERE EXISTS (SELECT 1
57: FROM OKL_CURE_PAYMENT_LINES
58: WHERE status = 'CURES_IN_POSSESSION'
59: AND cured_flag = 'Y'

Line 57: FROM OKL_CURE_PAYMENT_LINES

53: CURSOR c_cured (p_chr_id NUMBER) is
54: SELECT 'Y'
55: FROM OKL_CURE_PAYMENT_LINES
56: WHERE EXISTS (SELECT 1
57: FROM OKL_CURE_PAYMENT_LINES
58: WHERE status = 'CURES_IN_POSSESSION'
59: AND cured_flag = 'Y'
60: AND chr_id = p_chr_id);
61: ls_cured_flag VARCHAR2(1) := 'N';