DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_PROCESS_PVT dependencies on OKL_TRX_TYPES_TL

Line 4829: FROM okl_trx_types_tl t

4825: CURSOR l_try_id_csr (
4826: cp_try_name IN VARCHAR2,
4827: cp_language IN VARCHAR2) IS
4828: SELECT id
4829: FROM okl_trx_types_tl t
4830: WHERE Upper (t.name) LIKE Upper (cp_try_name)
4831: AND t.language = Upper (cp_language);
4832:
4833: l_try_id number default null;

Line 7556: okl_trx_types_tl ttl

7552: --cursor to read whether product change or customer change
7553: cursor l_relk_reason_csr(p_chr_id in number) is
7554: select tcn.rbr_code
7555: from okl_trx_contracts tcn,
7556: okl_trx_types_tl ttl
7557: where ttl.id = tcn.try_id
7558: and ttl.language = 'US'
7559: and ttl.name = 'Release'
7560: and tcn.tsu_code = 'ENTERED'