APPS.OKL_ACCOUNTING_PROCESS_PVT dependencies on OKL_TXL_CNTRCT_LNS

Line 178: FROM OKL_TXL_CNTRCT_LNS tcl,

174:
175: CURSOR trx_csr(v_source_id NUMBER) IS
176: SELECT tcn.trx_number,
177: try.trx_type_class
178: FROM OKL_TXL_CNTRCT_LNS tcl,
179: OKL_TRX_CONTRACTS tcn,
180: OKL_TRX_TYPES_V try
181: WHERE tcl.id = v_source_id
182: AND tcl.tcn_id = tcn.id

Line 254: IF (dists_rec.source_table = 'OKL_TXL_CNTRCT_LNS') THEN

250: l_gl_date := dist_rec.gl_date;
251:
252: END LOOP;
253:
254: IF (dists_rec.source_table = 'OKL_TXL_CNTRCT_LNS') THEN
255: OPEN trx_csr(dists_rec.source_id);
256: FETCH trx_csr INTO l_trx_number,
257: l_trx_type_class;
258: IF (trx_csr%NOTFOUND) THEN

Line 659: okl_txl_cntrct_lns txl,

655: CURSOR trx_cntrct_csr (p_source_id NUMBER) IS
656: SELECT
657: tcn.try_id
658: FROM
659: okl_txl_cntrct_lns txl,
660: okl_trx_contracts tcn
661: WHERE
662: txl.id = p_source_id AND
663: txl.tcn_id = tcn.id;

Line 719: IF dist_rec.source_table = 'OKL_TXL_CNTRCT_LNS' THEN

715: l_aelv_tbl_in(i).REFERENCE2 := dist_rec.ID;
716:
717: -- Added by santonyr bug 3925719
718:
719: IF dist_rec.source_table = 'OKL_TXL_CNTRCT_LNS' THEN
720: FOR trx_cntrct_rec IN trx_cntrct_csr (dist_rec.source_id) LOOP
721: l_aelv_tbl_in(i).REFERENCE3 := trx_cntrct_rec.try_id;
722: END LOOP;
723: ELSIF dist_rec.source_table = 'OKL_TXL_ASSETS_B' THEN

Line 1047: okl_txl_cntrct_lns tcl,

1043: ael.currency_code currency_code,
1044: aeh.ae_category ae_category
1045: FROM okl_ae_lines ael,
1046: okl_ae_headers aeh,
1047: okl_txl_cntrct_lns tcl,
1048: okl_trx_contracts tcn
1049: WHERE aeh.ae_header_id = ael.ae_header_id
1050: AND aeh.accounting_error_code IS NULL
1051: AND ael.accounting_error_code IS NULL

Line 1071: okl_txl_cntrct_lns tcl,

1067: ael.currency_code
1068: FROM okl_Ae_headers aeh,
1069: okl_ae_lines ael,
1070: okl_trx_types_v try,
1071: okl_txl_cntrct_lns tcl,
1072: okl_trx_contracts tcn
1073: WHERE aeh.ae_header_id=ael.ae_header_id
1074: AND aeh.accounting_error_code IS NULL
1075: AND ael.accounting_error_code IS NULL

Line 1173: okl_txl_cntrct_lns tcl,

1169: tcl.currency_code currency_code,
1170: tcl.amount amount,
1171: tcn.date_transaction_occurred transaction_date
1172: FROM
1173: okl_txl_cntrct_lns tcl,
1174: okl_trx_contracts tcn,
1175: okl_trx_types_v try,
1176: okc_k_headers_b khr
1177: WHERE