APPS.PAY_PAYGB45L_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 dual
 where not exists
     (select 1
      from fnd_sessions fs
      where fs.session_id = userenv('sessionid'));

Line: 29

   select substr(pay_gb_eoy_archive.get_parameter
                (p.legislative_parameters,'TAX_REF'),1,3),
        substr(ltrim(substr(pay_gb_eoy_archive.get_parameter
                (p.legislative_parameters,'TAX_REF'),4,11),'/') ,1,10),
        substr(pay_gb_eoy_archive.get_arch_str
                (p.payroll_action_id,
                 'X_EMPLOYERS_ADDRESS_LINE','0'),1,60),
        substr(pay_gb_eoy_archive.get_arch_str
                (p.payroll_action_id,
                 'X_EMPLOYERS_NAME','0'),1,40)
 into   C_TAX_DIST_NO, C_TAX_DIST_REF, l_ers_address, C_ERS_NAME
 from   pay_payroll_actions p
 where  p.payroll_action_id = P_PAYROLL_ACTION_ID;

Line: 133

  /* insert into log_msg values('sampath','paygb45l','C_TAX_TD_POUNDS',C_TAX_TD_POUNDS);

Line: 259

Select 1 into l_3_part
from   ff_globals_f
where  GLOBAL_NAME = 'P45_REPORT_TYPE'
and    substr(GLOBAL_VALUE,1,1) = '3'
and    sysdate between effective_start_date and effective_end_date;