DBA Data[Home] [Help]

APPS.OKL_INS_QUOTE_PVT dependencies on OKC_K_LINES_V

Line 4677: OKC_K_LINES_V CLE, OKC_LINE_STYLES_B LS

4673: --- Loan Contract
4674: CURSOR c_loan_asset_category(p_khr_id NUMBER) IS
4675: select 'x',CLE.NAME , cle.id
4676: from OKL_K_LINES KLE,
4677: OKC_K_LINES_V CLE, OKC_LINE_STYLES_B LS
4678: WHERE CLE.ID = KLE.ID
4679: and CLE.STS_CODE NOT IN ( 'TERMINATED' , 'EXPIRED','ABANDONED' )
4680: and KLE.ITEM_INSURANCE_CATEGORY IS NULL
4681: AND LS.LTY_CODE = 'FREE_FORM1'