APPS.OKL_GL_TRANSFER_PVT dependencies on OKL_AE_HEADERS

Line 149: FROM okl_Ae_headers aeh,

145: try.name try_name,
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

Line 172: FROM okl_Ae_headers aeh,

168: try.name try_name,
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

Line 202: FROM okl_ae_headers aeh,

198: ael.accounted_dr,
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

Line 226: FROM okl_ae_headers aeh,

222: ael.accounted_dr,
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

Line 236: FROM okl_ae_headers aeh,

232:
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;