APPS.OKL_BILLING_CONTROLLER_PVT dependencies on OKL_K_HEADERS

Line 34: OKL_K_HEADERS khl,

30: FROM OKL_STRM_ELEMENTS ste,
31: OKL_STREAMS stm,
32: okl_strm_type_v sty,
33: okc_k_headers_b khr,
34: OKL_K_HEADERS khl,
35: okc_k_lines_b kle,
36: okc_statuses_b khs,
37: okc_statuses_b kls
38: WHERE ste.amount <> 0

Line 81: okl_k_headers_full_v khr

77:
78: cursor khr_bill_date_csr( p_khr_id NUMBER ) is
79: select nbd.khr_id
80: from okl_k_control nbd,
81: okl_k_headers_full_v khr
82: where nbd.khr_id = khr.id
83: and khr.id = p_khr_id;
84:
85: l_khr_id number;

Line 1163: ,okl_k_headers khr

1159: cursor check_contract_type(p_contract_number VARCHAR2) IS
1160: select decode(chr.scs_code, 'INVESTOR', 'IA', 'LEASE', 'C', null)
1161: from
1162: okc_k_headers_all_b chr
1163: ,okl_k_headers khr
1164: where chr.id = khr.id
1165: and chr.scs_code in ('INVESTOR', 'LEASE')
1166: and chr.contract_number = p_contract_number;
1167: