APPS.PER_PERUSADA_XMLP_PKG SQL Statements

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

Line: 9

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: 23

select to_number(rule_mode)
into   c_disability_id_flex_num
from   pay_legislation_rules
where  legislation_code = 'US'
and    rule_type = 'ADA_DIS';

Line: 28

select to_number(rule_mode)
into   c_disability_acc_id_flex_num
from   pay_legislation_rules
where  legislation_code = 'US'
and    rule_type = 'ADA_DIS_ACC';

Line: 41

     select employee_number
     into   c_employee_number
     from   per_all_people_f
     where  person_id = p_employee_number;

Line: 53

     select name
     into   c_job_name
     from   per_jobs_vl
     where  job_id = p_job_id;

Line: 65

     select location_code
     into   c_location_code
     from   hr_locations
     where  location_id = p_location;