DBA Data[Home] [Help]

APPS.OKL_EXT_BILLING_CHARGES_PVT dependencies on OKL_TRX_TYPES_TL

Line 157: FROM okl_trx_types_tl

153: WHERE contract_number = p_contract_number;
154:
155: CURSOR get_try_id_csr (cp_name VARCHAR2, cp_language VARCHAR2) IS
156: SELECT id
157: FROM okl_trx_types_tl
158: WHERE name = cp_name
159: AND LANGUAGE = cp_language;
160:
161: CURSOR get_sty_id_csr ( p_sty_name VARCHAR2, p_purpose_code VARCHAR2 ) IS

Line 207: l_try_id okl_trx_types_tl.id%type;

203: -- Local Variables
204: -- ********************************
205: l_khr_id okc_k_headers_b.id%type;
206: l_kle_id NUMBER;
207: l_try_id okl_trx_types_tl.id%type;
208: l_sty_id okl_strm_type_b.id%type;
209: l_currency_code fnd_currencies.currency_code%type;
210: l_khr_currency fnd_currencies.currency_code%type;
211: l_amount okl_trx_ar_invoices_v.amount%TYPE;