DBA Data[Home] [Help]

APPS.OKL_LOAN_BAL_UPDATE_PVT dependencies on OKC_K_LINES_V

Line 74: FROM okc_k_lines_v assets

70: -- Cursor to obtain the Assets in a contract
71: CURSOR get_assets(cp_khr_id NUMBER) IS
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