DBA Data[Home] [Help]

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 1200: ,okl_k_headers khr

1196: cursor check_contract_type(p_contract_number VARCHAR2) IS
1197: select decode(chr.scs_code, 'INVESTOR', 'IA', 'LEASE', 'C', null)
1198: from
1199: okc_k_headers_all_b chr
1200: ,okl_k_headers khr
1201: where chr.id = khr.id
1202: and chr.scs_code in ('INVESTOR', 'LEASE')
1203: and chr.contract_number = p_contract_number;
1204: