APPS.PAY_PAYRPHTS_XMLP_PKG SQL Statements

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

Line: 13

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

	SELECT parameter_value
	INTO l_trace_value
	FROM pay_action_parameters
	WHERE parameter_name = 'TRACE';

Line: 57

select meaning
into v_meaning
from hr_lookups
where lookup_type = 'TRIGGER_STATUS'
and lookup_code = P_STATUS_1;