The following lines contain the word 'select', 'insert', 'update' or 'delete':
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)
);
select
nvl(UPPER(hoi.org_information11),' ') sender_id,
hoi.org_information1 paye_ref,
hoi.organization_id orgid,
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;
select
hoi.org_information2 sautr,
hoi.org_information3 cotaxref
from hr_organization_information hoi
where hoi.organization_id = orgid
and hoi.org_information_context = 'Tax Details References Cont'
and hoi.org_information1 = paye_ref;
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;
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;
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;
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;