APPS.OKL_GL_TRANSFER_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 122: okl_txl_cntrct_lns tcl

118: tcl.line_number
119: FROM okl_trx_contracts tcn,
120: okl_trx_types_v try,
121: okc_k_headers_b khr,
122: okl_txl_cntrct_lns tcl
123: WHERE tcn.id = tcl.tcn_id AND
124: tcn.try_id = try.id AND
125: tcn.khr_id = khr.id AND
126: tcl.id = l_source_id;

Line 152: okl_txl_cntrct_lns tcl,

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
155: AND aeh.accounting_error_code IS NULL
156: AND ael.accounting_error_code IS NULL

Line 204: okl_txl_cntrct_lns tcl,

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
208: AND aeh.request_id = p_request_id

Line 401: IF (gl_proc_dst_rec.source_table='OKL_TXL_CNTRCT_LNS') THEN

397: ae_category_rec.try_id,
398: ae_category_rec.currency_code)
399: LOOP
400:
401: IF (gl_proc_dst_rec.source_table='OKL_TXL_CNTRCT_LNS') THEN
402:
403: OPEN cntrct_details_csr(gl_proc_dst_rec.source_id) ;
404: FETCH cntrct_details_csr INTO l_temp_trx_number,
405: l_temp_contract_number ,

Line 522: IF (gl_error_dst_rec.source_table='OKL_TXL_CNTRCT_LNS') THEN

518: CLOSE gl_error_dst_csr;
519:
520: FOR gl_error_dst_rec IN gl_error_dst_csr(p_request_id) LOOP
521:
522: IF (gl_error_dst_rec.source_table='OKL_TXL_CNTRCT_LNS') THEN
523:
524: OPEN cntrct_details_csr(gl_error_dst_rec.source_id) ;
525: FETCH cntrct_details_csr INTO l_temp_trx_number,
526: l_temp_contract_number ,