APPS.PAY_FR_ARC_UTL SQL Statements

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

Line: 15

  select parameter_value
  from pay_action_parameters
  where parameter_name = 'RANGE_PERSON_ID';

Line: 20

  select par.parameter_value
  from   pay_payroll_actions            ppa,
         pay_report_format_mappings_f   map,
         pay_report_format_parameters   par
  where  ppa.payroll_action_id        = p_payroll_action_id
  and    map.report_type              = ppa.report_type
  and    map.report_category          = ppa.report_category
  and    map.report_qualifier         = ppa.report_qualifier
  and    ppa.effective_date     between map.effective_start_date
                                    and map.effective_end_date
  and    map.report_format_mapping_id = par.report_format_mapping_id
  and    par.parameter_name           = 'RANGE_PERSON_ID';