APPS.OKL_TCL_PVT dependencies on OKL_TRX_CONTRACTS

Line 815: FROM OKL_TRX_CONTRACTS

811: item_not_found_error EXCEPTION;
812:
813: CURSOR okl_tclv_fk_csr (p_id IN NUMBER) IS
814: SELECT '1'
815: FROM OKL_TRX_CONTRACTS
816: WHERE OKL_TRX_CONTRACTS.id = p_id;
817:
818:
819: BEGIN

Line 816: WHERE OKL_TRX_CONTRACTS.id = p_id;

812:
813: CURSOR okl_tclv_fk_csr (p_id IN NUMBER) IS
814: SELECT '1'
815: FROM OKL_TRX_CONTRACTS
816: WHERE OKL_TRX_CONTRACTS.id = p_id;
817:
818:
819: BEGIN
820: -- initialize return status

Line 2891: FROM okl_trx_contracts

2887: -- Cursor to fetch the currency code of a transaction
2888:
2889: CURSOR trx_curr_csr (l_id NUMBER) IS
2890: SELECT currency_code
2891: FROM okl_trx_contracts
2892: WHERE id = l_id;
2893:
2894: BEGIN
2895: x_tclv_rec := p_tclv_rec;