DBA Data[Home] [Help]

APPS.OKL_LOAN_BAL_UPDATE_PVT dependencies on OKC_K_HEADERS_B

Line 59: OKC_K_HEADERS_B CHR

55: /*CURSOR check_contract_loan_bal(p_contract_number VARCHAR2) IS
56: SELECT
57: KHR.ID
58: FROM
59: OKC_K_HEADERS_B CHR
60: , OKL_K_HEADERS KHR
61: , OKL_PRODUCT_PARAMETERS_V PPM
62: , OKC_STATUSES_V STS
63: WHERE chr.id = khr.id

Line 375: FROM okc_k_headers_b chr

371: sts.code status,
372: ppm.deal_type,
373: ppm.interest_calculation_basis ,
374: ppm.revenue_recognition_method
375: FROM okc_k_headers_b chr
376: , okl_k_headers khr
377: , okl_product_parameters_v ppm
378: , okc_statuses_v sts
379: WHERE chr.contract_number = NVL(cp_contract_number, chr.contract_number)