APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_TRX_ASSETS

Line 6828: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

6824: --Bug# 6344223
6825: --Cursor to check whether split asset transaction is in progress for the contract
6826: CURSOR check_split_trx_csr IS
6827: SELECT tas.id
6828: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
6829: WHERE txl.tal_type= 'ALI'
6830: AND txl.dnz_khr_id = p_khr_id
6831: AND txl.tas_id = tas.id
6832: AND tas.tas_type = 'ALI'

Line 6835: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

6831: AND txl.tas_id = tas.id
6832: AND tas.tas_type = 'ALI'
6833: AND tas.tsu_code = 'ENTERED';
6834:
6835: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
6836: --end Bug# 6344223
6837:
6838: BEGIN
6839: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 9101: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

9097: --Bug# 6344223
9098: --Cursor to check whether split asset transaction is in progress for the contract
9099: CURSOR check_split_trx_csr IS
9100: SELECT tas.id
9101: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
9102: WHERE txl.tal_type= 'ALI'
9103: AND txl.dnz_khr_id = p_khr_id
9104: AND txl.tas_id = tas.id
9105: AND tas.tas_type = 'ALI'

Line 9108: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

9104: AND txl.tas_id = tas.id
9105: AND tas.tas_type = 'ALI'
9106: AND tas.tsu_code = 'ENTERED';
9107:
9108: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
9109: --end Bug# 6344223
9110:
9111: BEGIN
9112: IF (G_DEBUG_ENABLED = 'Y') THEN