APPS.OKL_XLA_EVENTS_PVT dependencies on OKL_TRX_CONTRACTS

Line 157: FROM okl_trx_contracts

153: trunc(date_transaction_occurred) transaction_date,
154: trunc(canceled_date) cancelled_date,
155: trx_number,
156: try_id
157: FROM okl_trx_contracts
158: WHERE id = p_tcn_id;
159:
160: get_tcn_rec get_tcn_csr%ROWTYPE;
161:

Line 388: FROM okl_trx_contracts

384: TRUNC(date_transaction_occurred) transaction_date,
385: TRUNC(canceled_date) cancelled_date,
386: trx_number,
387: try_id
388: FROM okl_trx_contracts
389: WHERE id = p_tcn_id;
390:
391: get_tcn_rec get_tcn_csr%ROWTYPE;
392:

Line 591: FROM okl_trx_contracts

587: trunc(date_transaction_occurred) transaction_date,
588: trunc(canceled_date) cancelled_date,
589: trx_number,
590: try_id
591: FROM okl_trx_contracts
592: WHERE id = p_tcn_id;
593:
594: get_tcn_rec get_tcn_csr%ROWTYPE;
595:

Line 837: FROM okl_trx_contracts_all

833: trunc(canceled_date) cancelled_date,
834: trx_number,
835: try_id,
836: representation_code
837: FROM okl_trx_contracts_all
838: WHERE id = p_tcn_id;
839:
840: get_tcn_rec get_tcn_csr%ROWTYPE;
841:

Line 1174: FROM okl_trx_contracts

1170: trunc(date_transaction_occurred) transaction_date,
1171: trunc(canceled_date) cancelled_date,
1172: trx_number,
1173: try_id
1174: FROM okl_trx_contracts
1175: WHERE id = p_tcn_id;
1176:
1177: get_tcn_rec get_tcn_csr%ROWTYPE;
1178:

Line 1360: FROM okl_trx_contracts

1356: TRUNC(date_transaction_occurred) transaction_date,
1357: TRUNC(canceled_date) cancelled_date,
1358: trx_number,
1359: try_id
1360: FROM okl_trx_contracts
1361: WHERE id = p_tcn_id;
1362:
1363: get_tcn_rec get_tcn_csr%ROWTYPE;
1364:

Line 1560: FROM okl_trx_contracts

1556: TRUNC(date_transaction_occurred) transaction_date,
1557: TRUNC(canceled_date) cancelled_date,
1558: trx_number,
1559: try_id
1560: FROM okl_trx_contracts
1561: WHERE id = p_tcn_id;
1562:
1563: get_tcn_rec get_tcn_csr%ROWTYPE;
1564:

Line 1758: FROM okl_trx_contracts

1754: TRUNC(date_transaction_occurred) transaction_date,
1755: TRUNC(canceled_date) cancelled_date,
1756: trx_number,
1757: try_id
1758: FROM okl_trx_contracts
1759: WHERE id = p_tcn_id;
1760:
1761: get_tcn_rec get_tcn_csr%ROWTYPE;
1762:

Line 1955: FROM okl_trx_contracts

1951: TRUNC(date_transaction_occurred) transaction_date,
1952: TRUNC(canceled_date) cancelled_date,
1953: trx_number,
1954: try_id
1955: FROM okl_trx_contracts
1956: WHERE id = p_tcn_id;
1957:
1958: get_tcn_rec get_tcn_csr%ROWTYPE;
1959: