APPS.PAY_PYCAROEP_XMLP_PKG SQL Statements

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

Line: 7

select upper(parameter_value)
from pay_action_parameters
where parameter_name='TRACE';

Line: 12

select full_name
from per_all_people_f
where person_id=p_person_id;

Line: 16

CURSOR csr_get_sel_type(p_selection_type varchar2) is
select meaning
from hr_lookups
where lookup_type = 'PAY_CA_ROE_SELECTION_TYPE'
  and lookup_code = p_selection_type;

Line: 25

l_selection_type varchar2(80);

Line: 29

select assignment_set_name
from hr_assignment_sets
where assignment_set_id = p_assignment_set;

Line: 65

  IF p_selection_type is not null then

     open csr_get_sel_type(p_selection_type);

Line: 68

     Fetch csr_get_sel_type into l_selection_type;

Line: 75

     CP_selection_type := l_selection_type;

Line: 143

  cursor cur_lookup is select
   meaning from hr_lookups
   where lookup_type = 'PAY_CA_CORRESPONDENCE_LANGUAGE'
   and   lookup_code = ROE_PER_CORRESPONDENCE_LANG1;

Line: 167

  select
     ptpv.DISPLAY_PERIOD_TYPE
  from
     per_time_period_types_vl ptpv
  where
     ptpv.period_type = ROE_PAY_PERIOD_TYPE1;

Line: 212

 Function CP_selection_type_p return varchar2 is
	Begin
	 return CP_selection_type;