APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_TYPES_TL

Line 1625: FROM okl_trx_types_tl

1621: WHERE id = p_chr_id;
1622:
1623: CURSOR try_csr(p_trx_type_name VARCHAR2) IS
1624: SELECT id
1625: FROM okl_trx_types_tl
1626: WHERE language = 'US'
1627: AND name = p_trx_type_name;
1628:
1629: l_dummy VARCHAR2(1);

Line 3265: FROM okl_trx_types_tl try

3261: AND tcn.representation_type = 'PRIMARY'
3262: AND (tcn.tcn_type IN ('TRBK','RVS','SPLC')
3263: --
3264: OR (tcn.tcn_type = 'MAE' AND tcn.try_id IN (SELECT try.id
3265: FROM okl_trx_types_tl try
3266: WHERE try.name = 'Release'
3267: AND try.language= 'US')));
3268:
3269: --Bug# 4905732

Line 8818: okl_trx_types_tl try

8814: --Bug 6657564- Added
8815: RBR_CODE
8816: --Bug 6657564 - End
8817: FROM okl_trx_contracts tcn,
8818: okl_trx_types_tl try
8819: WHERE tcn.khr_id_old = p_orig_chr_id
8820: AND tcn.khr_id_new = p_new_chr_id
8821: AND tcn_type = 'MAE'
8822: AND tcn.tsu_code <> 'PROCESSED'