APPS.PAY_US_ARCHIVE_RULES SQL Statements

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

Line: 52

   select ppa.legislative_parameters
   into lv_legislative_param
   from pay_payroll_actions ppa
   where payroll_action_id = pactid;

Line: 84

   SELECT effective_date,
          pay_core_utils.get_parameter('TRANSFER_GRE',legislative_parameters)
     INTO ld_effective_date,
          ln_tax_unit_id
     FROM pay_payroll_actions
    WHERE payroll_action_id = pactid;

Line: 94

   sqlstr := sqlstr ||' AND not exists (SELECT 1
                            FROM pay_payroll_actions ppa,
                                 pay_assignment_actions paa
                           WHERE ppa.report_type = ''YREND''
                             AND ppa.action_status = ''C''
                             AND ppa.effective_date = '''|| ld_year_end ||'''
                             AND pay_core_utils.get_parameter(
                                 ''TRANSFER_GRE'',
                                 legislative_parameters) = '|| ln_tax_unit_id ||'
                             AND ppa.payroll_action_id = paa.payroll_action_id
                             AND paa.action_status = ''C''
                             AND ppa.business_group_id = paf.business_group_id
                             AND paa.serial_number = TO_CHAR(paf.person_id))';

Line: 128

   select ppa.legislative_parameters
   into lv_legislative_param
   from pay_payroll_actions ppa
   where payroll_action_id = pactid;