The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TP.end_date
INTO l_period_end_date
FROM per_time_periods TP
,pay_payroll_actions PACT
WHERE PACT.payroll_action_id = p_owner_payroll_action_id
AND PACT.payroll_id = TP.payroll_id
AND p_owner_effective_date BETWEEN TP.start_date AND TP.end_date;
SELECT bd.period_type
,pact.business_group_id
FROM pay_payroll_actions pact
,hr_organization_information hoi
,pay_balance_dimensions bd
WHERE pact.payroll_action_id = p_payroll_action_id
AND hoi.organization_id = pact.business_group_id
AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND bd.dimension_name = p_dimension_name
AND bd.legislation_code = hoi.org_information9;
SELECT bd.period_type
,pact.business_group_id
FROM pay_payroll_actions pact
,hr_organization_information hoi
,pay_balance_dimensions bd
WHERE pact.payroll_action_id = p_payroll_action_id
AND hoi.organization_id = pact.business_group_id
AND UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND bd.dimension_name = p_dimension_name
AND bd.legislation_code = hoi.org_information9;