[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT meaning into l_value
FROM hr_lookups
WHERE lookup_type = 'TITLE'
AND lookup_code = p_person_columns.TITLE;
select lookup_code token_name
from hr_standard_lookups
where lookup_type = 'PER_FORMAT_MASK_TOKENS';
select rowid row_id
,FIRST_NAME
,MIDDLE_NAMES
,LAST_NAME
,SUFFIX
,PRE_NAME_ADJUNCT
,TITLE
,KNOWN_AS
,EMAIL_ADDRESS
,EMPLOYEE_NUMBER
,APPLICANT_NUMBER
,NPW_NUMBER
,PREVIOUS_LAST_NAME
,PER_INFORMATION1
,PER_INFORMATION2
,PER_INFORMATION3
,PER_INFORMATION4
,PER_INFORMATION5
,PER_INFORMATION6
,PER_INFORMATION7
,PER_INFORMATION8
,PER_INFORMATION9
,PER_INFORMATION10
,PER_INFORMATION11
,PER_INFORMATION12
,PER_INFORMATION13
,PER_INFORMATION14
,PER_INFORMATION15
,PER_INFORMATION16
,PER_INFORMATION17
,PER_INFORMATION18
,PER_INFORMATION19
,PER_INFORMATION20
,PER_INFORMATION21
,PER_INFORMATION22
,PER_INFORMATION23
,PER_INFORMATION24
,PER_INFORMATION25
,PER_INFORMATION26
,PER_INFORMATION27
,PER_INFORMATION28
,PER_INFORMATION29
,PER_INFORMATION30
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,ATTRIBUTE16
,ATTRIBUTE17
,ATTRIBUTE18
,ATTRIBUTE19
,ATTRIBUTE20
,ATTRIBUTE21
,ATTRIBUTE22
,ATTRIBUTE23
,ATTRIBUTE24
,ATTRIBUTE25
,ATTRIBUTE26
,ATTRIBUTE27
,ATTRIBUTE28
,ATTRIBUTE29
,ATTRIBUTE30
,FULL_NAME
,ORDER_NAME
,LOCAL_NAME
,GLOBAL_NAME
,BUSINESS_GROUP_ID
from per_all_people_f
where rowid = p_rowid;
select format_mask
from hr_name_formats
where format_name = cp_format_name
and user_format_choice = cp_user_format_choice
and ((cp_legislation_code is not null
and legislation_code = cp_legislation_code)
or (cp_legislation_code is null and legislation_code is null));
select rowid, business_group_id, full_name, order_name
,local_name, global_name
from per_all_people_f
where person_id = p_person_id
and p_effective_date between effective_start_date and effective_end_date;
select 'TRUE'
from hr_name_formats
where format_name = p_format_name
and ((p_legislation is not null and legislation_code = p_legislation)
or legislation_code is null);
select bg.legislation_code
from per_all_people_f peo
,per_business_groups_perf bg
where peo.person_id = p_person_id
and p_effective_date between peo.effective_start_date and peo.effective_end_date
and peo.business_group_id = bg.business_group_id;
select '1'
from user_objects
where object_name = cp_pkg
and object_type = 'PACKAGE';
SELECT object_name
FROM user_objects
WHERE object_type='PACKAGE BODY'
AND object_name = cp_pkg
AND length(object_name)=13
ORDER BY object_name;
l_proc_call := 'SELECT rtrim(substrb( '|| l_package_name ||'.'||l_procedure_name||'(:p_first_name,:p_middle_names,:p_last_name,:p_known_as,:p_title,';
select nmf.format_mask
from HR_NAME_FORMATS nmf
where nmf.format_name = cp_format_name
and (cp_legcode is not null and nmf.legislation_code = cp_legcode
or
cp_legcode is null and nmf.legislation_code is null)
and nmf.user_format_choice = cp_user_format_choice;
SELECT 'Y'
INTO l_status
FROM sys.dual
WHERE EXISTS (SELECT /*+ no_expand */ 'Duplicate Person Exists'
FROM per_all_people_f pp
WHERE /* Perform case insensitive check on last name */
/* trying to use the index on last name */
upper(pp.last_name) = upper(p_last_name)
AND ( pp.last_name like l_ul_check
OR pp.last_name like l_lu_check
OR pp.last_name like l_uu_check
OR pp.last_name like l_ll_check
)
AND (upper(pp.first_name) = upper(p_first_name)
OR p_first_name IS NULL
OR pp.first_name IS NULL)
AND (pp.date_of_birth = p_date_of_birth
OR p_date_of_birth IS NULL
OR pp.date_of_birth IS NULL)
AND ((p_person_id IS NOT NULL
AND p_person_id <> pp.person_id)
OR p_person_id IS NULL)
AND pp.business_group_id +0 = p_business_group_id
AND -- Include Kanji Name for JP Legislation
(
l_legislation_code <> 'JP'
OR
(
l_legislation_code = 'JP'
AND
(
upper(pp.per_information18) = upper(p_per_information18)
OR p_per_information18 IS NULL
OR pp.per_information18 IS NULL
)
AND
(
upper(pp.per_information19) = upper(p_per_information19)
OR p_per_information19 IS NULL
OR pp.per_information18 IS NULL
)
)
)
);
select lookup_code token_name, meaning token_desc
from hr_standard_lookups
where lookup_type = 'PER_FORMAT_MASK_TOKENS';
select meaning token_desc
from hr_standard_lookups
where lookup_type = 'PER_FORMAT_MASK_TOKENS'
and lookup_code = cp_token;
select nmf.format_mask
from HR_NAME_FORMATS nmf
where nmf.format_name = cp_format_name
and (cp_legcode is not null and nmf.legislation_code = cp_legcode
or
cp_legcode is null and nmf.legislation_code is null)
and nmf.user_format_choice = cp_user_format_choice;