APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKL_BPD_LEASING_PAYMENT_TRX_V

Line 6954: FROM okl_bpd_leasing_payment_trx_v

6950: -- Cursor for outstanding amount
6951: -- Bug 5897792
6952: /*CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
6953: SELECT NVL(SUM(amount_due_remaining), 0)
6954: FROM okl_bpd_leasing_payment_trx_v
6955: WHERE contract_id = p_chr_id;*/
6956:
6957: CURSOR outstanding_amount_csr (p_chr_id IN NUMBER) IS
6958: SELECT NVL(SUM(amount_due_remaining), 0)

Line 7478: FROM okl_bpd_leasing_payment_trx_v

7474: ,p_kle_id IN NUMBER
7475: ,p_sty_id IN NUMBER)
7476: IS
7477: SELECT NVL(SUM(amount_due_original - amount_due_remaining),0) total_amount
7478: FROM okl_bpd_leasing_payment_trx_v
7479: WHERE contract_id = p_dnz_chr_id
7480: AND contract_line_id = p_kle_id
7481: AND stream_type_id = p_sty_id
7482: AND amount_due_original <> amount_due_remaining;