APPS.OKL_GL_TRANSFER_PVT dependencies on OKL_AE_LINES

Line 150: okl_ae_lines ael,

146: try.id try_id,
147: aeh.ae_category ae_category,
148: ael.currency_code
149: FROM okl_Ae_headers aeh,
150: okl_ae_lines ael,
151: okl_trx_types_v try,
152: okl_txl_cntrct_lns tcl,
153: okl_trx_contracts tcn
154: WHERE aeh.ae_header_id=ael.ae_header_id

Line 173: okl_ae_lines ael,

169: try.id try_id,
170: aeh.ae_category ae_category,
171: ael.currency_code
172: FROM okl_Ae_headers aeh,
173: okl_ae_lines ael,
174: okl_trx_types_v try,
175: okl_trx_assets tas,
176: okl_txl_assets_b tal
177: WHERE aeh.ae_header_id=ael.ae_header_id

Line 203: okl_ae_lines ael,

199: ael.accounted_cr,
200: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
201: ael.currency_code
202: FROM okl_ae_headers aeh,
203: okl_ae_lines ael,
204: okl_txl_cntrct_lns tcl,
205: okl_trx_contracts tcn
206: WHERE ael.ae_header_id = aeh.ae_header_id
207: AND ael.gl_transfer_error_code is null

Line 227: okl_ae_lines ael

223: ael.accounted_cr,
224: okl_Accounting_util.get_concat_segments(ael.code_combination_id) account,
225: ael.currency_code
226: FROM okl_ae_headers aeh,
227: okl_ae_lines ael
228: WHERE ael.ae_header_id = aeh.ae_header_id
229: AND ael.gl_transfer_error_code is not null
230: AND aeh.request_id = p_request_id
231: ORDER BY ael.source_id;

Line 237: okl_ae_lines ael

233: CURSOR header_details_csr(p_request_id NUMBER) IS
234: SELECT count(*) total,
235: ael.gl_transfer_error_code
236: FROM okl_ae_headers aeh,
237: okl_ae_lines ael
238: WHERE aeh.request_id = p_request_id
239: AND aeh.ae_header_id = ael.ae_header_id
240: GROUP BY ael.gl_transfer_error_code;
241: