172: AND language = userenv('LANG');
173:
174: CURSOR sales_grp_name_csr IS
175: SELECT group_name
176: FROM jtf_rs_groups_tl
177: WHERE group_id = p_sales_group_id
178: AND language = userenv('LANG');
179:
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:
189: BEGIN