The following lines contain the word 'select', 'insert', 'update' or 'delete':
select freeze_status_cd
from pqh_templates a
where a.template_id = p_template_id;
select nvl(enable_flag,'N')
from pqh_attributes a
where a.attribute_id = p_attribute_id;
select att.attribute_name
from pqh_attributes_vl att,pqh_template_attributes tat
where tat.attribute_id = p_attribute_id
and tat.template_id = p_template_id
and tat.attribute_id = att.attribute_id;
l_select_flag pqh_txn_category_attributes.select_flag%type;
select transaction_category_id
from pqh_templates a
where a.template_id = p_template_id;
select nvl(tca.select_flag,'N')
from pqh_attributes att , pqh_txn_category_attributes tca
where att.attribute_id = p_attribute_id
AND att.attribute_id = tca.attribute_id
AND tca.transaction_category_id = l_tem_tct;
fetch c2 into l_select_flag;
If l_select_flag <> 'Y' then
hr_utility.set_message(8302,'PQH_ATTRIBUTE_NOT_SELECTABLE');
select legislation_code, template_name
from pqh_templates_vl
where template_id = p_template_id;
select legislation_code, attribute_name
from pqh_attributes_vl
where attribute_id = p_attribute_id;
Procedure insert_validate(p_rec in pqh_tat_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in pqh_tat_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'update_validate';
End update_validate;
Procedure delete_validate(p_rec in pqh_tat_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;
Select attribute_name
From pqh_attributes
Where attribute_id = p_attribute_id;