APPS.PAY_PAYGBSOE_XMLP_PKG SQL Statements

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

Line: 28

select end_date
from   per_time_periods
where  time_period_id = p_time_period_id;

Line: 47

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

Line: 54

select session_id
into l_test
from fnd_sessions
where session_id = userenv('sessionid');

Line: 117

  Select segment_name into b from fnd_id_flex_segments_vl
  where application_id between 801 and 899
  and id_flex_code = 'GRP'
  and application_column_name = a
  and id_flex_num = (Select people_group_structure from per_business_groups
                     Where business_group_id = p_bus_grp_id);

Line: 274

   select currency_code
     into currency_code
     from per_business_groups
    where business_group_id=p_bus_grp_id;