The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT o.organization_id
FROM hr_all_organization_units o,
hr_organization_information o2,
hr_organization_information o3
WHERE o.organization_id = o2.organization_id
AND o.organization_id = o3.organization_id
AND o3.organization_id = o2.organization_id
AND o2.org_information_context || '' = 'CLASS'
AND o3.org_information_context = 'Operating Unit Information'
AND o2.org_information1 = 'OPERATING_UNIT'
AND o2.org_information2 = 'Y'
AND o.organization_id = p_org_id;
SELECT to_number(o3.org_information3)
FROM hr_organization_information o3,
hr_all_organization_units o,
hr_organization_information o2
WHERE o.organization_id = o2.organization_id
AND o.organization_id = o3.organization_id
AND o3.organization_id = o2.organization_id
AND o2.org_information_context || '' = 'CLASS'
AND o3.org_information_context = 'Operating Unit Information'
AND o2.org_information1 = 'OPERATING_UNIT'
AND o2.org_information2 = 'Y'
AND o.organization_id = p_org_id;
cursor acct_env_type(l_sob_id IN NUMBER) is select accounting_env_type from xle_sob_interface where set_of_books_id = l_sob_id;
cursor def_legal_context(l_sob_id IN VARCHAR2) is select legal_entity_Id from xle_le_sob_interface where set_of_books_id = l_sob_id;
cursor check_le(p_org_Id IN NUMBER) is select legal_entity_id from xle_le_ou_interface where organization_id = p_org_id;
select O3.org_information2
from
HR_ALL_ORGANIZATION_UNITS O,
HR_ORGANIZATION_INFORMATION O2,
HR_ORGANIZATION_INFORMATION O3
where
O.organization_id=p_org_id
AND O.ORGANIZATION_ID = O2.ORGANIZATION_ID
AND O.ORGANIZATION_ID = O3.ORGANIZATION_ID
AND O2.ORG_INFORMATION_CONTEXT = 'CLASS'
AND O3.ORG_INFORMATION_CONTEXT = 'Operating Unit Information'
AND O2.ORG_INFORMATION1 = 'OPERATING_UNIT'
AND O2.ORG_INFORMATION2 = 'Y'
and exists(select le.legal_entity_id from xle_le_interface le where le.legal_entity_id = O3.org_information2);
cursor le_bsv(l_sob_id IN NUMBER) is select legal_entity_id from xle_le_bsv_interface where set_of_books_id = l_sob_id and rownum = 1;