DBA Data[Home] [Help]

APPS.OKL_LOAN_BAL_UPDATE_PVT dependencies on OKC_STATUSES_V

Line 62: , OKC_STATUSES_V STS

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
64: AND khr.pdt_id = ppm.id
65: AND chr.sts_code = sts.code
66: AND (sts.code = 'BOOKED' OR sts.ste_code = 'TERMINATED')

Line 76: ,okc_statuses_v sts

72: SELECT assets.id asset_id
73: , assets.name asset_number
74: FROM okc_k_lines_v assets
75: , okc_line_styles_b lse
76: ,okc_statuses_v sts
77: WHERE assets.dnz_chr_id = cp_khr_id
78: AND lse.id = assets.lse_id
79: AND lse.lty_code = 'FREE_FORM1'
80: AND assets.sts_code = sts.code

Line 378: , okc_statuses_v sts

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)
380: AND chr.id = khr.id
381: AND khr.pdt_id = ppm.id
382: AND chr.sts_code = sts.code