APPS.CN_ADD_TBH_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 46

   select s.sales_credit_type_id
     from cn_rs_salesreps s,
	  jtf_rs_resource_extns r
    where s.salesrep_id = p_mgr_srp_id
      and s.resource_id = r.resource_id;

Line: 189

     select to_number(replace(emp_num,tbh_pre,'')) n
       from cn_srp_hr_data
      where emp_num like tbh_pre || '%'
        and emp_num not like tbh_pre || '%-%'
        and category = 'TBH'
      order by n;