APPS.OKL_CONTRACT_REBOOK_PVT dependencies on OKL_TRX_ASSETS

Line 8497: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

8493: --Bug# 6344223
8494: --Cursor to check whether split asset transaction is in progress for the contract
8495: CURSOR check_split_trx_csr IS
8496: SELECT tas.id
8497: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
8498: WHERE txl.tal_type= 'ALI'
8499: AND txl.dnz_khr_id = p_khr_id
8500: AND txl.tas_id = tas.id
8501: AND tas.tas_type = 'ALI'

Line 8504: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

8500: AND txl.tas_id = tas.id
8501: AND tas.tas_type = 'ALI'
8502: AND tas.tsu_code = 'ENTERED';
8503:
8504: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
8505: --end Bug# 6344223
8506:
8507: BEGIN
8508: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 10869: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas

10865: --Bug# 6344223
10866: --Cursor to check whether split asset transaction is in progress for the contract
10867: CURSOR check_split_trx_csr IS
10868: SELECT tas.id
10869: FROM OKL_TXL_ASSETS_B txl, OKL_TRX_ASSETS tas
10870: WHERE txl.tal_type= 'ALI'
10871: AND txl.dnz_khr_id = p_khr_id
10872: AND txl.tas_id = tas.id
10873: AND tas.tas_type = 'ALI'

Line 10876: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;

10872: AND txl.tas_id = tas.id
10873: AND tas.tas_type = 'ALI'
10874: AND tas.tsu_code = 'ENTERED';
10875:
10876: l_split_trans_id OKL_TRX_ASSETS.ID%TYPE;
10877: --end Bug# 6344223
10878:
10879: BEGIN
10880: IF (G_DEBUG_ENABLED = 'Y') THEN