APPS.PAY_CA_ARCHIVE_RULES SQL Statements

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

Line: 58

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

Line: 69

                     (   select 1
                         from hr_organization_information hoi
                         where hoi.org_information_context =  ''Canada Employer Identification''
                         and hoi.org_information2  = '''|| l_pre_organization_id||'''
                         and hoi.org_information5 in (''T4/RL1'',''T4A/RL1'',''T4A/RL2'')
                         and PAA.tax_unit_id=hoi.organization_id
                      )';

Line: 102

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

Line: 120

                     (   select 1
                         from hr_organization_information hoi
                         where hoi.org_information_context =  ''Canada Employer Identification''
                         and hoi.org_information2  = '''|| l_pre_organization_id||'''
                         and hoi.org_information5 in (''T4/RL1'',''T4A/RL1'',''T4A/RL2'')
                         and PAA.tax_unit_id=hoi.organization_id
                      )';

Line: 128

   sqlstr := sqlstr ||'AND not exists (SELECT 1
                            FROM pay_payroll_actions ppa,
                                 pay_assignment_actions paa
                           WHERE ppa.report_type = ''' || l_report_type ||
                             ''' AND ppa.action_status = ''C''
                             AND ppa.effective_date = '''|| ld_year_end ||'''
                             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: 142

				( select 1
				  from  pay_assignment_actions paa,
					per_all_assignments_f paaf,
					hr_locations hl
				  where paa.payroll_action_id = ppa.payroll_action_id
					and paa.assignment_id = paaf.assignment_id
					and paaf.person_id = paf.person_id --Added lastly
					and paaf.location_id = hl.location_id
					and hl.region_1= ''QC'') ';

Line: 173

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

Line: 183

                     (   select 1
                         from hr_organization_information hoi
                         where hoi.org_information_context =  ''Canada Employer Identification''
                         and hoi.org_information2  = '''|| l_pre_organization_id||'''
                         and hoi.org_information5 in (''T4/RL1'',''T4A/RL1'',''T4A/RL2'')
                         and PAA.tax_unit_id=hoi.organization_id
                      )';