APPS.SSP_SSPRPSSP_XMLP_PKG SQL Statements

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

Line: 9

Select payroll_name
  from pay_payrolls_f
 where business_group_id = p_business_group_id
   and payroll_id        = p_payroll_id
   and effective_start_date <= p_date_to
   and effective_end_date >= p_date_from
order by effective_start_date desc;

Line: 18

Select full_name
  from per_people_f
 where person_id = p_person_id
   and business_group_id = p_business_group_id
   and effective_start_date <= p_date_to
   and effective_end_date >= p_date_from
order by effective_start_date desc;

Line: 29

   insert into fnd_sessions
      (session_id, effective_date)
   select userenv('sessionid'),
          trunc(sysdate)
   from   sys.dual
   where  not exists
             (select 1
              from   fnd_sessions fs
              where  fs.session_id = userenv('sessionid'));