APPS.OKL_LA_SALES_TAX_PVT dependencies on OKL_TRX_TYPES_TL

Line 856: p_transaction_type IN okl_trx_types_tl.name%TYPE,

852: Procedure populate_transaction(
853: p_api_version IN NUMBER,
854: p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE,
855: p_contract_id IN okc_k_headers_all_b.id%TYPE,
856: p_transaction_type IN okl_trx_types_tl.name%TYPE,
857: p_transaction_id IN okl_trx_contracts_all.id%TYPE DEFAULT NULL,
858: p_source_trx_id IN okl_trx_contracts_all.source_trx_id%TYPE DEFAULT NULL,
859: p_source_trx_type IN okl_trx_contracts_all.source_trx_type%TYPE DEFAULT NULL,
860: --Bug# 6619311

Line 881: FROM okl_trx_types_tl

877:
878: CURSOR Transaction_Type_csr (p_transaction_type IN okl_trx_types_v.name%TYPE )
879: IS
880: SELECT id
881: FROM okl_trx_types_tl
882: WHERE name = p_transaction_type
883: AND language = 'US';
884:
885: Cursor trx_csr( khrId NUMBER, tcntype VARCHAR2 ) is

Line 5165: FROM OKL_TRX_TYPES_TL

5161: WHERE ID = p_contract_id;
5162:
5163: CURSOR c_try_type(p_name IN VARCHAR2) IS
5164: SELECT ID
5165: FROM OKL_TRX_TYPES_TL
5166: WHERE name = p_name
5167: AND LANGUAGE = 'US';
5168:
5169: l_currency_code VARCHAR2(15);