APPS.OKL_CS_LC_CONTRACT_PVT dependencies on OKL_CS_BPD_INV_DTL_V

Line 1953: FROM okl_cs_bpd_inv_dtl_v

1949:
1950: FUNCTION get_total_billed(p_khr_id IN NUMBER) RETURN NUMBER IS
1951: CURSOR c_get_billed(cp_khr_id IN NUMBER) IS
1952: SELECT SUM(amount_original+amount_adjusted)
1953: FROM okl_cs_bpd_inv_dtl_v
1954: WHERE amount_remaining > 0
1955: AND chr_id = cp_khr_id;
1956:
1957: /* CURSOR c_get_total_adjusted(cp_khr_id IN NUMBER) IS

Line 1987: FROM okl_cs_bpd_inv_dtl_v

1983:
1984: FUNCTION get_total_paid_credited(p_khr_id IN NUMBER) RETURN NUMBER IS
1985: CURSOR c_get_paid_credited(cp_khr_id IN NUMBER) IS
1986: SELECT SUM(amount_applied) + SUM(amount_credited)
1987: FROM okl_cs_bpd_inv_dtl_v
1988: WHERE -- amount_remaining > 0 -- fox for bug 14524398 : vsgandhi
1989: --AND
1990: chr_id = cp_khr_id;
1991: l_paid_credited NUMBER;

Line 2004: FROM okl_cs_bpd_inv_dtl_v

2000:
2001: FUNCTION get_total_remaining(p_khr_id IN NUMBER) RETURN NUMBER IS
2002: CURSOR c_get_remaining(cp_khr_id IN NUMBER) IS
2003: SELECT SUM(amount_remaining)
2004: FROM okl_cs_bpd_inv_dtl_v
2005: WHERE amount_remaining > 0
2006: AND chr_id = cp_khr_id;
2007: l_remaining NUMBER;
2008: BEGIN