The following lines contain the word 'select', 'insert', 'update' or 'delete':
select pbg.security_group_id,
pbg.legislation_code
from per_business_groups_perf pbg
, pqh_fr_stat_situations sts
where sts.statutory_situation_id = p_statutory_situation_id
and pbg.business_group_id = sts.business_group_id;
select pbg.legislation_code
from per_business_groups_perf pbg
, pqh_fr_stat_situations sts
where sts.statutory_situation_id = p_statutory_situation_id
and pbg.business_group_id = sts.business_group_id;
Procedure chk_non_updateable_args
(p_effective_date in date
,p_rec in pqh_sts_shd.g_rec_type
) IS
--
l_proc varchar2(72) := g_package || 'chk_non_updateable_args';
End chk_non_updateable_args;
fnd_message.set_name('PQH','PQH_FR_FREQUENCY_MUST_SELECT');
Select null
from hr_lookups
Where Lookup_type='PROC_PERIOD_TYPE'
and ENABLED_FLAG='Y'
and lookup_code = p_frequency;
Select null
from hr_lookups
where lookup_type ='FR_PQH_STAT_SIT_REASON'
and lookup_code like p_situation_type || '%'
and lookup_code = p_reason
and enabled_flag = 'Y';
Select null
from hr_lookups
Where Lookup_type='FR_PQH_STAT_SIT_PLCMENT'
and ENABLED_FLAG='Y'
and lookup_code = p_location;
Select null
from hr_lookups
Where Lookup_type='FR_PQH_STAT_SIT_SOURCE'
and ENABLED_FLAG='Y'
and lookup_code = p_source;
Select null
from hr_lookups
where lookup_type ='FR_PQH_STAT_SIT_SUB_TYPE'
and lookup_code like p_situation_type || '%'
and lookup_code = p_sub_type
and enabled_flag = 'Y';
Select null
from pqh_fr_stat_situations
where
type_of_ps = p_rec.type_Of_ps
and situation_type = p_rec.situation_type
and statutory_situation_id <> nvl(p_rec.statutory_situation_id,-1)
and business_group_id = p_rec.business_group_id
and default_flag = 'Y';
Select null
From per_shared_types_vl
Where shared_type_id = to_number(p_type_of_ps);
Select null
from hr_lookups
Where Lookup_type='FR_PQH_STAT_SIT_TYPE'
and ENABLED_FLAG='Y'
and lookup_code =p_situation_type;
Select situation_name
from pqh_fr_stat_situations
where situation_name = p_rec.situation_name
and business_group_id = p_rec.business_group_id
and statutory_situation_id <> nvl(p_rec.statutory_situation_id,-1);
Select null
from pqh_fr_stat_situations
where
type_of_ps = p_rec.type_Of_ps
and situation_type = p_rec.situation_type
and nvl(sub_type,'-1') = nvl(p_rec.sub_type,'-1')
and nvl(source,'-1') = nvl(p_rec.source,'-1')
and nvl(location,'-1') = nvl(p_rec.location,'-1')
and nvl(reason,'-1') = nvl(p_rec.reason,'-1')
and business_group_id = p_rec.business_group_id
and statutory_situation_id <> nvl(p_rec.statutory_situation_id,-1);
Procedure insert_validate
(p_effective_date in date
,p_rec in pqh_sts_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate
(p_effective_date in date
,p_rec in pqh_sts_shd.g_rec_type
) 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 pqh_sts_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;