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 371: FROM okl_trx_contracts

367: TRUNC(date_transaction_occurred) transaction_date,
368: TRUNC(canceled_date) cancelled_date,
369: trx_number,
370: try_id
371: FROM okl_trx_contracts
372: WHERE id = p_tcn_id;
373:
374: get_tcn_rec get_tcn_csr%ROWTYPE;
375:

Line 574: FROM okl_trx_contracts

570: trunc(date_transaction_occurred) transaction_date,
571: trunc(canceled_date) cancelled_date,
572: trx_number,
573: try_id
574: FROM okl_trx_contracts
575: WHERE id = p_tcn_id;
576:
577: get_tcn_rec get_tcn_csr%ROWTYPE;
578:

Line 820: FROM okl_trx_contracts_all

816: trunc(canceled_date) cancelled_date,
817: trx_number,
818: try_id,
819: representation_code
820: FROM okl_trx_contracts_all
821: WHERE id = p_tcn_id;
822:
823: get_tcn_rec get_tcn_csr%ROWTYPE;
824:

Line 1157: FROM okl_trx_contracts

1153: trunc(date_transaction_occurred) transaction_date,
1154: trunc(canceled_date) cancelled_date,
1155: trx_number,
1156: try_id
1157: FROM okl_trx_contracts
1158: WHERE id = p_tcn_id;
1159:
1160: get_tcn_rec get_tcn_csr%ROWTYPE;
1161:

Line 1343: FROM okl_trx_contracts

1339: TRUNC(date_transaction_occurred) transaction_date,
1340: TRUNC(canceled_date) cancelled_date,
1341: trx_number,
1342: try_id
1343: FROM okl_trx_contracts
1344: WHERE id = p_tcn_id;
1345:
1346: get_tcn_rec get_tcn_csr%ROWTYPE;
1347:

Line 1543: FROM okl_trx_contracts

1539: TRUNC(date_transaction_occurred) transaction_date,
1540: TRUNC(canceled_date) cancelled_date,
1541: trx_number,
1542: try_id
1543: FROM okl_trx_contracts
1544: WHERE id = p_tcn_id;
1545:
1546: get_tcn_rec get_tcn_csr%ROWTYPE;
1547:

Line 1741: FROM okl_trx_contracts

1737: TRUNC(date_transaction_occurred) transaction_date,
1738: TRUNC(canceled_date) cancelled_date,
1739: trx_number,
1740: try_id
1741: FROM okl_trx_contracts
1742: WHERE id = p_tcn_id;
1743:
1744: get_tcn_rec get_tcn_csr%ROWTYPE;
1745:

Line 1938: FROM okl_trx_contracts

1934: TRUNC(date_transaction_occurred) transaction_date,
1935: TRUNC(canceled_date) cancelled_date,
1936: trx_number,
1937: try_id
1938: FROM okl_trx_contracts
1939: WHERE id = p_tcn_id;
1940:
1941: get_tcn_rec get_tcn_csr%ROWTYPE;
1942: