The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT SUBSTR(TRIM(
TRIM(p_last_name)
|| ', '
||TRIM(p_first_name)
||' '
||TRIM(p_middle_name)
||' '
||TRIM(p_per_information1))
, 1, 240)
INTO l_full_name
FROM dual;
SELECT SUBSTR(TRIM(p_last_name)||','||TRIM(p_first_name) ||
DECODE(TRIM(P_MIDDLE_NAME),NULL,'', ',' || TRIM(p_middle_name)), 1, 240)
INTO l_order_name
FROM dual;
select SOFT_CODING_KEYFLEX_ID
from PER_ALL_ASSIGNMENTS_F
where assignment_id = p_assignment_id;
select ORGANIZATION_ID
from PER_ALL_ASSIGNMENTS_F
where assignment_id = p_assignment_id;
select lookups.meaning
from HR_SOFT_CODING_KEYFLEX scl, hr_lookups lookups
where scl.SOFT_CODING_KEYFLEX_ID = l_scl_id
and lookups.lookup_type=l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',scl.segment3,
'DK_EMP_GROUP',scl.segment4,NULL);
select lookups.meaning
from hr_organization_units hou, hr_organization_information hoi , hr_lookups lookups
where hou.organization_id = l_organization_id
and hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
and lookups.lookup_type = l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',hoi.org_information1,
'DK_EMP_GROUP',hoi.org_information2,NULL);
select segment2
from hr_soft_coding_keyflex
where soft_coding_keyflex_id = l_scl_id;
select lookups.meaning
from hr_organization_information hoi , hr_lookups lookups
where hoi.organization_id = l_org_id
and hoi.org_information_context = 'DK_EMPLOYMENT_DEFAULTS'
and lookups.lookup_type = l_information_code
and lookups.enabled_flag = 'Y'
and lookups.lookup_code = decode(l_information_code,'DK_COND_OF_EMP',hoi.org_information1,
'DK_EMP_GROUP',hoi.org_information2,NULL);
select business_group_id
from hr_organization_units
where organization_id = l_organization_id;
select nvl(hoi.org_information1,'NO_DATA')
from hr_organization_units hou , hr_organization_information hoi
where hou.organization_id = l_organization_id
and hou.organization_id = hoi.organization_id
and hoi.org_information_context = 'CLASS'
and hoi.org_information1 = 'HR_ORG';