The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT TO_DATE(ru.rule_mode || '/' || TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
FROM per_business_groups bg
,pay_legislation_rules ru
WHERE bg.business_group_id = p_business_group_id
AND ru.legislation_code = bg.legislation_code
AND ru.rule_type = 'L';
SELECT TO_DATE(TO_CHAR(fnd_date.canonical_to_date(hoi.org_information11), 'DD/MM/')
|| TO_CHAR(p_effective_date, 'YYYY'), 'DD/MM/YYYY')
FROM hr_organization_information HOI
WHERE UPPER(hoi.org_information_context) = 'BUSINESS GROUP INFORMATION'
AND hoi.organization_id = p_business_group_id;