APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_CURE_PAYMENT_LINES

Line 7503: FROM OKL_CURE_PAYMENT_LINES

7499: RETURN NUMBER IS
7500: -- Cursor to get Cures in Possession
7501: CURSOR cures_in_possession_csr(p_chr_id IN NUMBER) IS
7502: SELECT NVL(SUM(amount),0)
7503: FROM OKL_CURE_PAYMENT_LINES
7504: WHERE chr_id = p_chr_id
7505: AND status = 'CURES_IN_POSSESSION'
7506: AND cured_flag = 'Y';
7507:

Line 7742: FROM OKL_cure_payment_lines_v

7738:
7739: -- Get unrefunded cures for a contract
7740: /*CURSOR unrefunded_cures_csr(p_contract_id NUMBER) IS
7741: SELECT SUM(amount)
7742: FROM OKL_cure_payment_lines_v
7743: WHERE chr_id = p_contract_id
7744: AND status = 'CURES_IN_POSSESSION'; */
7745:
7746: l_unrefunded_cures NUMBER := 0;

Line 7781: FROM OKL_CURE_PAYMENT_LINES

7777: FUNCTION get_cured_status (p_contract_number IN NUMBER)
7778: RETURN VARCHAR2 IS
7779: CURSOR c_cured (p_chr_id NUMBER) IS
7780: SELECT 'Y'
7781: FROM OKL_CURE_PAYMENT_LINES
7782: WHERE EXISTS (SELECT 1
7783: FROM OKL_CURE_PAYMENT_LINES
7784: WHERE status = 'CURES_IN_POSSESSION'
7785: AND cured_flag = 'Y'

Line 7783: FROM OKL_CURE_PAYMENT_LINES

7779: CURSOR c_cured (p_chr_id NUMBER) IS
7780: SELECT 'Y'
7781: FROM OKL_CURE_PAYMENT_LINES
7782: WHERE EXISTS (SELECT 1
7783: FROM OKL_CURE_PAYMENT_LINES
7784: WHERE status = 'CURES_IN_POSSESSION'
7785: AND cured_flag = 'Y'
7786: AND chr_id = p_chr_id);
7787: ls_cured_flag VARCHAR2(1) := 'N';