6514: FROM okc_k_headers_b chr,
6515: okl_k_headers khr,
6516: okc_statuses_b khs,
6517: okl_product_parameters_v ppm,
6518: hz_cust_accounts hca --- Added as part of Bug# 14119181
6519: WHERE CHR.CONTRACT_NUMBER = NVL(p_contract_number,CHR.CONTRACT_NUMBER)
6520: AND khr.deal_type IN ('LOAN','LEASEDF','LOAN-REVOLVING','LEASEST','LEASEOP')
6521: AND chr.id = khr.id
6522: AND khs.code = chr.sts_code