APPS.OKL_TIL_PVT dependencies on OKL_TRX_AR_INVOICES_B

Line 152: FROM OKL_TRX_AR_INVOICES_B

148: l_dummy_var VARCHAR2(1) := '0';
149:
150: CURSOR l_tai_id_csr IS
151: SELECT '1'
152: FROM OKL_TRX_AR_INVOICES_B
153: WHERE id = p_tilv_rec.tai_id;
154:
155:
156: BEGIN

Line 219: OKL_TRX_AR_INVOICES_B invoice

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
223: AND line.dnz_chr_id = invoice.khr_id(+);

Line 310: OKL_TRX_AR_INVOICES_B invoice

306: SELECT '1'
307: FROM
308: OKL_STRM_TMPT_FULL_UV st,
309: OKL_K_HEADERS KHR,
310: OKL_TRX_AR_INVOICES_B invoice
311: WHERE
312: invoice.id = p_tilv_rec.tai_id
313: AND st.PDT_ID = khr.PDT_ID
314: AND st.TMPT_STATUS = 'ACTIVE'