APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_CS_PAYMENT_DETAIL_UV

Line 1641: SELECT sum(amount) from okl_cs_payment_detail_uv

1637: IS
1638: CURSOR c_strm_amount(p_khr_id IN NUMBER,
1639: p_kle_id IN NUMBER,
1640: p_sty_id IN NUMBER) IS
1641: SELECT sum(amount) from okl_cs_payment_detail_uv
1642: WHERE khr_id = p_khr_id
1643: AND sty_id = p_sty_id
1644: AND nvl(kle_id,-1) = nvl(p_kle_id,-1) ;
1645: l_strm_amount NUMBER;