[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select inf.org_information9
from hr_organization_information hoi
, hr_organization_information inf
where hoi.organization_id = p_BUSINESS_GROUP_ID
and hoi.org_information_context||'' = 'CLASS'
and hoi.org_information1 = 'HR_BG'
and hoi.org_information2 = 'Y'
and inf.organization_id = hoi.organization_id
and inf.org_information_context || '' = 'Business Group Information';
select distinct h.legislation_code
from HR_LEGISLATION_INSTALLATIONS h
where h.legislation_code = p_legislation_code
and h.status = 'I';
procedure update_range_table
( p_range_table_id in number
,p_object_version_number in out nocopy number
,p_range_table_number in number default hr_api.g_number
,p_period_frequency in varchar2 default hr_api.g_varchar2
,p_effective_start_date in date default hr_api.g_date
,p_effective_end_date in date default hr_api.g_date
,p_row_value_uom in varchar2 default hr_api.g_varchar2
,p_earnings_type in varchar2 default hr_api.g_varchar2
,p_business_group_id in number default hr_api.g_number
,p_legislation_code in varchar2 default hr_api.g_varchar2
,p_last_updated_login in number default hr_api.g_number
,p_created_date in date default hr_api.g_date
,p_attribute_category in varchar2 default hr_api.g_varchar2
,p_attribute1 in varchar2 default hr_api.g_varchar2
,p_attribute2 in varchar2 default hr_api.g_varchar2
,p_attribute3 in varchar2 default hr_api.g_varchar2
,p_attribute4 in varchar2 default hr_api.g_varchar2
,p_attribute5 in varchar2 default hr_api.g_varchar2
,p_attribute6 in varchar2 default hr_api.g_varchar2
,p_attribute7 in varchar2 default hr_api.g_varchar2
,p_attribute8 in varchar2 default hr_api.g_varchar2
,p_attribute9 in varchar2 default hr_api.g_varchar2
,p_attribute10 in varchar2 default hr_api.g_varchar2
,p_attribute11 in varchar2 default hr_api.g_varchar2
,p_attribute12 in varchar2 default hr_api.g_varchar2
,p_attribute13 in varchar2 default hr_api.g_varchar2
,p_attribute14 in varchar2 default hr_api.g_varchar2
,p_attribute15 in varchar2 default hr_api.g_varchar2
,p_attribute16 in varchar2 default hr_api.g_varchar2
,p_attribute17 in varchar2 default hr_api.g_varchar2
,p_attribute18 in varchar2 default hr_api.g_varchar2
,p_attribute19 in varchar2 default hr_api.g_varchar2
,p_attribute20 in varchar2 default hr_api.g_varchar2
,p_attribute21 in varchar2 default hr_api.g_varchar2
,p_attribute22 in varchar2 default hr_api.g_varchar2
,p_attribute23 in varchar2 default hr_api.g_varchar2
,p_attribute24 in varchar2 default hr_api.g_varchar2
,p_attribute25 in varchar2 default hr_api.g_varchar2
,p_attribute26 in varchar2 default hr_api.g_varchar2
,p_attribute27 in varchar2 default hr_api.g_varchar2
,p_attribute28 in varchar2 default hr_api.g_varchar2
,p_attribute29 in varchar2 default hr_api.g_varchar2
,p_attribute30 in varchar2 default hr_api.g_varchar2
,p_ran_information_category in varchar2 default hr_api.g_varchar2
,p_ran_information1 in varchar2 default hr_api.g_varchar2
,p_ran_information2 in varchar2 default hr_api.g_varchar2
,p_ran_information3 in varchar2 default hr_api.g_varchar2
,p_ran_information4 in varchar2 default hr_api.g_varchar2
,p_ran_information5 in varchar2 default hr_api.g_varchar2
,p_ran_information6 in varchar2 default hr_api.g_varchar2
,p_ran_information7 in varchar2 default hr_api.g_varchar2
,p_ran_information8 in varchar2 default hr_api.g_varchar2
,p_ran_information9 in varchar2 default hr_api.g_varchar2
,p_ran_information10 in varchar2 default hr_api.g_varchar2
,p_ran_information11 in varchar2 default hr_api.g_varchar2
,p_ran_information12 in varchar2 default hr_api.g_varchar2
,p_ran_information13 in varchar2 default hr_api.g_varchar2
,p_ran_information14 in varchar2 default hr_api.g_varchar2
,p_ran_information15 in varchar2 default hr_api.g_varchar2
,p_ran_information16 in varchar2 default hr_api.g_varchar2
,p_ran_information17 in varchar2 default hr_api.g_varchar2
,p_ran_information18 in varchar2 default hr_api.g_varchar2
,p_ran_information19 in varchar2 default hr_api.g_varchar2
,p_ran_information20 in varchar2 default hr_api.g_varchar2
,p_ran_information21 in varchar2 default hr_api.g_varchar2
,p_ran_information22 in varchar2 default hr_api.g_varchar2
,p_ran_information23 in varchar2 default hr_api.g_varchar2
,p_ran_information24 in varchar2 default hr_api.g_varchar2
,p_ran_information25 in varchar2 default hr_api.g_varchar2
,p_ran_information26 in varchar2 default hr_api.g_varchar2
,p_ran_information27 in varchar2 default hr_api.g_varchar2
,p_ran_information28 in varchar2 default hr_api.g_varchar2
,p_ran_information29 in varchar2 default hr_api.g_varchar2
,p_ran_information30 in varchar2 default hr_api.g_varchar2
)
IS
l_object_version_number number;
select inf.org_information9
from hr_organization_information hoi
, hr_organization_information inf
where hoi.organization_id = p_BUSINESS_GROUP_ID
and hoi.org_information_context||'' = 'CLASS'
and hoi.org_information1 = 'HR_BG'
and hoi.org_information2 = 'Y'
and inf.organization_id = hoi.organization_id
and inf.org_information_context || '' = 'Business Group Information';
select distinct h.legislation_code
from HR_LEGISLATION_INSTALLATIONS h
where h.legislation_code = p_legislation_code
and h.status = 'I';
end update_range_table;
procedure delete_range_table
( p_range_table_id in number
,p_object_version_number in number
)
IS
BEGIN
pay_prf_del.del
(
p_range_table_id => p_range_table_id
,p_OBJECT_VERSION_NUMBER => p_object_version_number
);
end delete_range_table;