APPS.PAY_GB_RTI_FPS_VALIDATE SQL Statements

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

Line: 50

  INSERT INTO pay_message_lines(line_sequence,
                                payroll_id,
                                message_level,
                                source_id,
                                source_type,
                                line_text)
                         VALUES(
                                pay_message_lines_s.nextval
                               ,100
                               ,'F'
                               ,p_assignment_action_id
                               ,'A'
                               ,substr(p_message_text,1,240)
                              );

Line: 87

             select
										nvl(UPPER(hoi.org_information11),' ') sender_id,
                    nvl(upper(substr(ltrim(hoi.org_information3),1,35)),' ') employer_name,
                    nvl(upper(substr(ltrim(substr(hoi.org_information1,4,11),'/'),1,10)),' ') tax_ref_no,
                    lpad(nvl(substr(hoi.org_information1,1,3),' '),3,0) tax_office_no,
										decode(PAY_GB_EOY_MAGTAPE.get_payroll_version, ' ', '0', PAY_GB_EOY_MAGTAPE.get_payroll_version) payroll_ver,
                    nvl(upper(substr(hoi.org_information6,1,13)),' ') acc_ref_no,
                    hoi.org_information7 econ,
                    SUBSTR(pay_gb_eoy_archive.get_parameter(legislative_parameters,'FIN_SUB'),1,20) final_submission
             from   pay_payroll_actions pact,
                    hr_organization_information hoi
            where   pact.payroll_action_id=pactid
              and   pact.business_group_id = hoi.organization_id
              and   hoi.org_information_context = 'Tax Details References'
              and   nvl(hoi.org_information10,'UK') = 'UK'
              and   substr(pact.legislative_parameters,instr(pact.legislative_parameters,'TAX_REF=') + 8,
                    instr(pact.legislative_parameters||' ',' ', instr(pact.legislative_parameters,'TAX_REF=')+8) -
                    instr(pact.legislative_parameters, 'TAX_REF=') - 8) = hoi.org_information1;

Line: 782

     SELECT ppa.effective_date
       FROM pay_payroll_actions ppa, pay_assignment_actions paa
      WHERE ppa.payroll_action_id = paa.payroll_action_id
        AND paa.assignment_action_id = p_assactid;

Line: 1312

     SELECT ppa.effective_date
       FROM pay_payroll_actions ppa, pay_assignment_actions paa
      WHERE ppa.payroll_action_id = paa.payroll_action_id
        AND paa.assignment_action_id = p_assactid;

Line: 1880

select paaf.assignment_number,papf.sex into l_assignment_number,l_gender from per_all_assignments_f paaf,
pay_assignment_Actions paa ,
per_all_people_f papf where
paa.assignment_action_id = p_assactid
and paa.assignment_id = paaf.assignment_id
and paaf.person_id = papf.person_id
and p_effective_date between paaf.effective_start_date and paaf.effective_end_date
and p_effective_date between papf.effective_start_date and papf.effective_end_date;

Line: 2354

     select pay_gb_eoy_archive.get_parameter(legislative_parameters, 'TEST'),
            /*ppa.effective_date*/
            sysdate
     from   pay_payroll_actions ppa
           ,pay_assignment_actions paa
     where paa.assignment_action_id =  c_assignment_action_id
           and ppa.payroll_action_id = paa.payroll_action_id;