The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pma.source_id
FROM pay_ca_pmed_accounts pma
WHERE pma.account_number = p_ac_no
AND pma.enabled = 'Y'
AND pma.business_group_id = p_bg_no;
SELECT pma.source_id,
pma.account_number
FROM hr_organization_information ogi1,
hr_organization_information ogi2,
pay_ca_pmed_accounts pma,
hr_organization_information ogi3,
hr_organization_information ogi4
WHERE ogi1.organization_id = p_gre
AND ogi1.org_information_context = 'CLASS'
AND ogi1.org_information1 = 'HR_LEGAL'
AND ogi1.org_information2 = 'Y'
AND ogi2.organization_id = p_gre
AND ogi2.org_information_context = 'Provincial Reporting Info.'
AND ogi2.org_information1 = p_juris
AND ogi2.org_information3 = pma.account_number
AND pma.enabled = 'Y'
AND pma.business_group_id = p_bg_no
AND ogi3.organization_id = pma.organization_id
AND ogi3.org_information_context = 'CLASS'
AND ogi3.org_information1 = 'CA_PMED'
AND ogi3.org_information2 = 'Y'
AND ogi4.organization_id = pma.organization_id
AND ogi4.org_information_context = 'Provincial Information'
AND ogi4.org_information1 = p_juris;
SELECT pma.source_id,
pma.account_number
FROM hr_organization_information ogi1,
hr_organization_information ogi2,
pay_ca_pmed_accounts pma,
hr_organization_information ogi3,
hr_organization_information ogi4
WHERE ogi1.organization_id = p_gre
AND ogi1.org_information_context = 'CLASS'
AND ogi1.org_information1 = 'HR_LEGAL'
AND ogi1.org_information2 = 'Y'
AND ogi2.organization_id = p_gre
AND ogi2.org_information_context = 'Provincial Reporting Info.'
AND ogi2.org_information1 = p_juris
AND ogi2.org_information3 = pma.account_number
AND pma.enabled = 'Y'
AND pma.business_group_id = p_bg_no
AND ogi3.organization_id = pma.organization_id
AND ogi3.org_information_context = 'CLASS'
AND ogi3.org_information1 = 'CA_PMED'
AND ogi3.org_information2 = 'Y'
AND ogi4.organization_id = pma.organization_id
AND ogi4.org_information_context = 'Provincial Information'
AND ogi4.org_information1 = p_juris;