APPS.SSP_SSPRPSAP_XMLP_PKG SQL Statements

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

Line: 12

   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'));

Line: 25

Select distinct  payroll_name into C_payroll_name
  from pay_payrolls
 where business_group_id = p_business_group_id
   and payroll_id        = p_payroll_id;

Line: 32

Select distinct substr(full_name,1,80) into C_person_name
  from per_people_f ppf
 where person_id = P_person_id
   and business_group_id = P_business_group_id
   and (
          (p_session_date between ppf.effective_start_date and ppf.effective_end_date)
          or
          (p_session_date > ppf.effective_end_date
           and ppf.effective_end_date = (select max(p1.effective_end_date)
                                           from per_all_people_f  p1
                                          where p1.person_id = ppf.person_id)
          )
          or
          (p_session_date < ppf.effective_start_date
           and ppf.effective_start_date = ppf.start_date
          )
       );

Line: 76

Select  average_earnings_amount into Avg_earnings
  from  ssp_earnings_calculations
 where  effective_date = Qw
   and  person_id = M_PERSON_ID;