The following lines contain the word 'select', 'insert', 'update' or 'delete':
select to_number(GLOBAL_VALUE)
into l_g_rate
from ff_globals_f
where global_name = 'NO_NATIONAL_INSURANCE_BASE_RATE'
and LEGISLATION_CODE = 'NO'
and BUSINESS_GROUP_ID IS NULL
and p_effective_date between EFFECTIVE_START_DATE and EFFECTIVE_END_DATE ;
SELECT end_date
FROM per_time_periods ptp
WHERE ptp.payroll_id = p_payroll_id
AND ptp.start_date = p_start_date;
SELECT MIN(paaf.effective_start_date) effective_start_date
FROM per_all_assignments_f paaf
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_asg_id
AND paaf.assignment_status_type_id = 3;
SELECT hsck.segment15 holiday_entitlement,
hsck.segment16 holiday_pay_calc_basis
FROM per_all_assignments_f paaf,
hr_soft_coding_keyflex hsck
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_asg_id
AND p_effective_date BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
SELECT papf.per_information16 holiday_entitlement,
papf.per_information17 holiday_pay_calc_basis
FROM per_all_people_f papf,
per_all_assignments_f paaf
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_asg_id
AND papf.person_id = paaf.person_id
AND p_effective_date BETWEEN papf.effective_start_date
AND papf.effective_end_date;
SELECT hoi.org_information1 holiday_entitlement,
hoi.org_information2 holiday_pay_calc_basis
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_tax_unit_id
AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
SELECT fgf.global_value
FROM ff_globals_f fgf
WHERE fgf.global_name = p_global_name
AND fgf.legislation_code = 'NO'
AND p_effective_date BETWEEN fgf.effective_start_date
AND fgf.effective_end_date;
SELECT period_num
FROM per_time_periods
WHERE payroll_id = p_payroll_id
AND to_char(start_date, 'YYYY') = to_char(p_start_date, 'YYYY')
AND prd_information2 = 'Y';
SELECT paaf.person_id
FROM per_all_assignments_f paaf
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_assg_id;
SELECT SUM(to_number(ppe.pem_information2))
FROM per_previous_employers ppe
WHERE ppe.business_group_id = p_business_group_id
AND ppe.person_id = p_person_id
AND to_char(ppe.end_date, 'YYYY') = to_char(p_emp_hire_date, 'YYYY')
AND to_char(ppe.end_date, 'YYYY') = to_char(p_asg_start_date, 'YYYY');
SELECT paaf.hourly_salaried_code hourly_salaried_code,
hsck.segment15 holiday_entitlement,
hsck.segment16 holiday_pay_calc_basis,
hsck.segment17 holiday_pay_in_fixed_period,
hsck.segment18 hol_pay_over60_in_fix_period,
hsck.segment19 holiday_pay_to_be_adjusted
FROM per_all_assignments_f paaf,
hr_soft_coding_keyflex hsck
WHERE paaf.business_group_id = p_bus_group_id
AND paaf.assignment_id = p_assignment_id
AND p_date_earned BETWEEN paaf.effective_start_date
AND paaf.effective_end_date
AND hsck.soft_coding_keyflex_id = paaf.soft_coding_keyflex_id;
SELECT papf.per_information6 hourly_salaried_code,
papf.per_information16 holiday_entitlement,
papf.per_information17 holiday_pay_calc_basis,
papf.per_information18 holiday_pay_in_fixed_period,
papf.per_information19 hol_pay_over60_in_fix_period,
papf.per_information20 holiday_pay_to_be_adjusted,
papf.per_information21 res_hol_pay_to_6g_for_over60
FROM per_all_people_f papf,
per_all_assignments_f paaf
WHERE paaf.business_group_id = p_bus_group_id
AND paaf.assignment_id = p_assignment_id
AND papf.person_id = paaf.person_id
AND p_date_earned BETWEEN papf.effective_start_date
AND papf.effective_end_date;
SELECT hoi.org_information1 holiday_entitlement,
hoi.org_information2 holiday_pay_calc_basis,
hoi.org_information3 holiday_pay_in_fixed_period,
hoi.org_information4 hol_pay_over60_in_fix_period,
hoi.org_information5 holiday_pay_to_be_adjusted,
hoi.org_information6 res_hol_pay_to_6g_for_over60
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_tax_unit_id
AND hoi.org_information_context = 'NO_HOLIDAY_PAY_DETAILS';
SELECT hoi.org_information5 hourly_salaried_code
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_tax_unit_id
AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';
SELECT MIN(paaf.effective_start_date)
FROM per_all_assignments_f paaf
WHERE paaf.business_group_id = p_business_group_id
AND paaf.assignment_id = p_assignment_id
AND paaf.assignment_status_type_id = 1;
SELECT
papf.per_information13 hol_accrual_entit
FROM per_all_people_f papf,
per_all_assignments_f paaf
WHERE paaf.business_group_id = p_bus_group_id
AND paaf.assignment_id = p_assignment_id
AND papf.person_id = paaf.person_id
AND p_date_earned BETWEEN papf.effective_start_date
AND papf.effective_end_date;
SELECT hoi.org_information9 hol_accrual_entit
FROM hr_organization_information hoi
WHERE hoi.organization_id = p_tax_unit_id
AND hoi.org_information_context = 'NO_ABSENCE_PAYMENT_DETAILS';