The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT to_number (
substr (
pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER'),
1,
LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'LEGAL_EMPLOYER')) - 1
)
) legal,
substr (
pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR'),
1,
LENGTH (pay_se_hcia_archive.get_parameter (legislative_parameters, 'REQUEST_FOR')) - 1
) request_for,
(pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_START_DATE')) eff_start_date,
(pay_se_hcia_archive.get_parameter (legislative_parameters, 'EFFECTIVE_END_DATE'))
eff_end_date,
effective_date effective_date, business_group_id bg_id
FROM pay_payroll_actions
WHERE payroll_action_id = p_payroll_action_id;
SELECT o1.NAME legal_employer_name, hoi2.org_information2 org_number, hoi1.organization_id legal_id
FROM hr_organization_units o1, hr_organization_information hoi1, hr_organization_information hoi2
WHERE o1.business_group_id = g_business_group_id
AND hoi1.organization_id = o1.organization_id
AND hoi1.organization_id = nvl (csr_v_legal_employer_id, hoi1.organization_id)
AND hoi1.org_information1 = 'HR_LEGAL_EMPLOYER'
AND hoi1.org_information_context = 'CLASS'
AND o1.organization_id = hoi2.organization_id
AND hoi2.org_information_context = 'SE_LEGAL_EMPLOYER_DETAILS';
SELECT count (*)
FROM per_all_people_f papf,
per_all_assignments_f paaf,
hr_soft_coding_keyflex hsc,
per_assignment_status_types past,
hr_organization_information hoi,
per_person_types ppt
WHERE paaf.person_id = papf.person_id
AND paaf.business_group_id = papf.business_group_id
AND hsc.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id
AND hsc.segment2 = hoi.org_information1
AND hoi.organization_id = p_legal_employer_id
AND ppt.system_person_type LIKE 'EMP%'
AND ppt.person_type_id = papf.person_type_id
AND papf.sex = p_gender_type
AND paaf.assignment_status_type_id = past.assignment_status_type_id
AND past.per_system_status = 'ACTIVE_ASSIGN'
AND paaf.primary_flag = 'Y'
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 DISTINCT person_id
FROM per_people_f ppf
,pay_payroll_actions ppa
WHERE ppa.payroll_action_id = :payroll_action_id
AND ppa.business_group_id = ppf.business_group_id
ORDER BY ppf.person_id';
p_sql := 'select 1 from dual where to_char(:payroll_action_id) = dummy';