DBA Data[Home] [Help]

APPS.OKL_TIL_PVT dependencies on OKC_K_LINES_B

Line 208: FROM OKC_K_LINES_B

204: -- sjalasut commented the cursor. see new cursor below
205: /*
206: CURSOR l_kle_id_csr IS
207: SELECT '1'
208: FROM OKC_K_LINES_B
209: WHERE id = p_tilv_rec.kle_id;
210: */
211: -- sjalasut: new cursor to validate that the asset and the contract are related
212: -- fix for bug 2783255

Line 218: FROM OKC_K_LINES_B line,

214: -- in the where clause
215: -- sjalasut: start of code changes
216: CURSOR l_kle_id_csr IS
217: SELECT '1'
218: FROM OKC_K_LINES_B line,
219: OKL_TRX_AR_INVOICES_B invoice
220: WHERE
221: line.id = p_tilv_rec.kle_id
222: AND invoice.id = p_tilv_rec.tai_id