APPS.OKL_UBB_PVT dependencies on OKL_TRX_TYPES_TL

Line 29: FROM okl_trx_types_tl

25: RETURN NUMBER IS
26:
27: CURSOR c_trx_type (cp_name VARCHAR2, cp_language VARCHAR2) IS
28: SELECT id
29: FROM okl_trx_types_tl
30: WHERE name = cp_name
31: AND LANGUAGE = cp_language;
32:
33: l_trx_type okl_trx_types_v.id%TYPE;

Line 75: l_try_id okl_trx_types_tl.id%TYPE;

71: l_date_billed_to OKS_BILL_CONT_LINES_V.DATE_BILLED_TO%TYPE;
72: l_amount OKS_BILL_CONT_LINES_V.AMOUNT%TYPE;
73: l_currency_code OKS_BILL_CONT_LINES_V.CURRENCY_CODE%TYPE;
74: l_cont_id OKS_BILL_CONT_LINES_V.ID%TYPE;
75: l_try_id okl_trx_types_tl.id%TYPE;
76: l_clg_id okl_trx_ar_invoices_v.clg_id%TYPE;
77: l_sty_id okl_strm_type_v.id%TYPE;
78: l_first_line CONSTANT NUMBER := 1;
79: l_line_step CONSTANT NUMBER := 1;

Line 174: SELECT ID FROM okl_trx_types_tl WHERE NAME = 'Billing' and LANGUAGE = 'US';

170:
171:
172:
173: CURSOR l_try_id_cur IS
174: SELECT ID FROM okl_trx_types_tl WHERE NAME = 'Billing' and LANGUAGE = 'US';
175: /*
176: CURSOR l_sty_id_cur IS
177: SELECT ID FROM okl_strm_type_v WHERE NAME = 'USAGE CHARGE';
178: */