APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_CURE_PAYMENT_LINES

Line 6905: FROM OKL_CURE_PAYMENT_LINES

6901: RETURN NUMBER IS
6902: -- Cursor to get Cures in Possession
6903: CURSOR cures_in_possession_csr(p_chr_id IN NUMBER) IS
6904: SELECT NVL(SUM(amount),0)
6905: FROM OKL_CURE_PAYMENT_LINES
6906: WHERE chr_id = p_chr_id
6907: AND status = 'CURES_IN_POSSESSION'
6908: AND cured_flag = 'Y';
6909:

Line 7144: FROM OKL_cure_payment_lines_v

7140:
7141: -- Get unrefunded cures for a contract
7142: /*CURSOR unrefunded_cures_csr(p_contract_id NUMBER) IS
7143: SELECT SUM(amount)
7144: FROM OKL_cure_payment_lines_v
7145: WHERE chr_id = p_contract_id
7146: AND status = 'CURES_IN_POSSESSION'; */
7147:
7148: l_unrefunded_cures NUMBER := 0;

Line 7183: FROM OKL_CURE_PAYMENT_LINES

7179: FUNCTION get_cured_status (p_contract_number IN NUMBER)
7180: RETURN VARCHAR2 IS
7181: CURSOR c_cured (p_chr_id NUMBER) IS
7182: SELECT 'Y'
7183: FROM OKL_CURE_PAYMENT_LINES
7184: WHERE EXISTS (SELECT 1
7185: FROM OKL_CURE_PAYMENT_LINES
7186: WHERE status = 'CURES_IN_POSSESSION'
7187: AND cured_flag = 'Y'

Line 7185: FROM OKL_CURE_PAYMENT_LINES

7181: CURSOR c_cured (p_chr_id NUMBER) IS
7182: SELECT 'Y'
7183: FROM OKL_CURE_PAYMENT_LINES
7184: WHERE EXISTS (SELECT 1
7185: FROM OKL_CURE_PAYMENT_LINES
7186: WHERE status = 'CURES_IN_POSSESSION'
7187: AND cured_flag = 'Y'
7188: AND chr_id = p_chr_id);
7189: ls_cured_flag VARCHAR2(1) := 'N';