The following lines contain the word 'select', 'insert', 'update' or 'delete':
select business_group_id
into p_business_group_id
from per_organization_structures
where p_organization_structure_id = organization_structure_id;
update per_org_structure_versions osv
set osv.date_to = (p_date_from - 1)
where osv.organization_structure_id = p_organization_Structure_Id
and osv.date_to is null
and osv.org_structure_version_id
<> nvl(p_org_structure_version_id,-1);
select org_structure_version_id,business_group_id
from per_org_structure_versions
where version_number = p_version_number
and nvl(p_org_structure_version_id,-1) <> org_structure_version_id
and p_organization_structure_id = organization_structure_id;
select count(*) as count
from per_organization_structures
where position_control_structure_flg = 'Y'
and p_organization_structure_id = organization_structure_id;
select count(*) as count
into l_count
from per_organization_structures
where p_organization_structure_id = organization_structure_id;
select max(osv.date_to)
into l_max_end_date
from per_org_structure_versions osv
where osv.date_from < p_Date_From
and osv.organization_structure_id = p_organization_structure_id
and osv.org_structure_Version_id = nvl(p_org_structure_version_id,-1);
select min(osv.date_from)
into l_min_start_date
from per_org_structure_versions osv
where osv.organization_structure_id = p_organization_structure_id
and osv.date_from > p_Date_To
and osv.org_structure_Version_id = nvl(p_org_structure_version_id,-1);
select null
into l_dummy
from dual
where exists
(select 1
from per_org_structure_versions osv
where osv.date_from <= nvl(p_Date_To, hr_api.g_eot)
and nvl(osv.date_to,hr_api.g_eot) >= p_Date_From
and osv.organization_structure_id = p_organization_structure_id
and osv.org_structure_version_id
<> nvl(p_org_structure_version_id,-1));
select pbg.security_group_id
from per_business_groups pbg
, per_org_structure_versions osv
where osv.org_structure_version_id = p_org_structure_version_id
and pbg.business_group_id = osv.business_group_id;
select pbg.legislation_code
from per_business_groups pbg
, per_org_structure_versions osv
where osv.org_structure_version_id = p_org_structure_version_id
and pbg.business_group_id (+) = osv.business_group_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in per_osv_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
Procedure insert_validate
(p_effective_date in date
,p_rec in per_osv_shd.g_rec_type
,p_gap_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in per_osv_shd.g_rec_type
,p_gap_warning out nocopy boolean
) is
--
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_effective_date => p_effective_date
,p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in per_osv_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;