APPS.OKC_REP_UPD_CON_ADMIN_PVT dependencies on OE_TRANSACTION_TYPES_TL

Line 170: FROM oe_transaction_types_tl

166: AND s.resource_id = jtf_res.resource_id;
167:
168: CURSOR trans_type_name_csr IS
169: SELECT name
170: FROM oe_transaction_types_tl
171: WHERE transaction_type_id = p_order_type_id
172: AND language = userenv('LANG');
173:
174: CURSOR sales_grp_name_csr IS

Line 184: l_trans_type_name oe_transaction_types_tl.name%TYPE;

180: l_doc_type_name okc_bus_doc_types_tl.name%TYPE;
181: l_cust_name hz_parties.party_name%TYPE;
182: l_ou_name hr_all_organization_units.name%TYPE;
183: l_salesperson_name jtf_rs_salesreps.name%TYPE;
184: l_trans_type_name oe_transaction_types_tl.name%TYPE;
185: l_sales_grp_name jtf_rs_groups_tl.group_name%TYPE;
186: l_con_admin_name per_all_people_f.full_name%TYPE;
187: l_not_available_text fnd_new_messages.message_text%TYPE;
188: