1911:
1912: FUNCTION get_total_billed(p_khr_id IN NUMBER) RETURN NUMBER IS
1913: CURSOR c_get_billed(cp_khr_id IN NUMBER) IS
1914: SELECT SUM(amount_original+amount_adjusted)
1915: FROM okl_cs_bpd_inv_dtl_v
1916: WHERE amount_remaining > 0
1917: AND chr_id = cp_khr_id;
1918:
1919: /* CURSOR c_get_total_adjusted(cp_khr_id IN NUMBER) IS
1945:
1946: FUNCTION get_total_paid_credited(p_khr_id IN NUMBER) RETURN NUMBER IS
1947: CURSOR c_get_paid_credited(cp_khr_id IN NUMBER) IS
1948: SELECT SUM(amount_applied) + SUM(amount_credited)
1949: FROM okl_cs_bpd_inv_dtl_v
1950: WHERE amount_remaining > 0
1951: AND chr_id = cp_khr_id;
1952: l_paid_credited NUMBER;
1953: BEGIN
1961:
1962: FUNCTION get_total_remaining(p_khr_id IN NUMBER) RETURN NUMBER IS
1963: CURSOR c_get_remaining(cp_khr_id IN NUMBER) IS
1964: SELECT SUM(amount_remaining)
1965: FROM okl_cs_bpd_inv_dtl_v
1966: WHERE amount_remaining > 0
1967: AND chr_id = cp_khr_id;
1968: l_remaining NUMBER;
1969: BEGIN