APPS.PAY_PAYKRSPL_XMLP_PKG SQL Statements

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

Line: 12

    p_selection_value := 'Cost_Center';

Line: 14

    p_selection_value := 'Establishment_name';

Line: 16

    p_selection_value := 'Grade_Name';

Line: 43

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

  select currency_code,name
  from   fnd_currencies_vl
  where  issuing_territory_code = c_territory_code;

Line: 93

   select period_name
     into v_period_name
    from per_time_periods
   where time_period_id=p_selection_date;