APPS.OKL_RELEASE_PVT dependencies on OKL_TRX_TYPES_TL

Line 1604: FROM okl_trx_types_tl

1600: WHERE id = p_chr_id;
1601:
1602: CURSOR try_csr(p_trx_type_name VARCHAR2) IS
1603: SELECT id
1604: FROM okl_trx_types_tl
1605: WHERE language = 'US'
1606: AND name = p_trx_type_name;
1607:
1608: l_dummy VARCHAR2(1);

Line 3211: FROM okl_trx_types_tl try

3207: AND tcn.representation_type = 'PRIMARY'
3208: AND (tcn.tcn_type IN ('TRBK','RVS','SPLC')
3209: --
3210: OR (tcn.tcn_type = 'MAE' AND tcn.try_id IN (SELECT try.id
3211: FROM okl_trx_types_tl try
3212: WHERE try.name = 'Release'
3213: AND try.language= 'US')));
3214:
3215: --Bug# 4905732

Line 8489: okl_trx_types_tl try

8485: --Bug 6657564- Added
8486: RBR_CODE
8487: --Bug 6657564 - End
8488: FROM okl_trx_contracts tcn,
8489: okl_trx_types_tl try
8490: WHERE tcn.khr_id_old = p_orig_chr_id
8491: AND tcn.khr_id_new = p_new_chr_id
8492: AND tcn_type = 'MAE'
8493: AND tcn.tsu_code <> 'PROCESSED'