APPS.PAY_PYKRSSEL_XMLP_PKG SQL Statements

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

Line: 8

 if p_selection_criteria = 'COST_CENTER' then
  p_parameter_name:= 'Cost Center';

Line: 11

 elsif p_selection_criteria ='ESTABLISHMENT_ID' then
p_parameter_name:= 'Organization';

Line: 14

elsif p_selection_criteria ='GRADE' then
p_parameter_name:= 'Grade';

Line: 46

  select org_information9
  from   hr_organization_information
  where  organization_id  = c_business_group_id
  and    org_information9 is not null
  and    org_information_context = 'Business Group Information';

Line: 67

  select currency_code, name
  from   fnd_currencies_vl
  where  issuing_territory_code = c_territory_code;

Line: 142

   select period_name
   into p_period_name
  from per_time_periods
  where time_period_id=p_selection_date;