The following lines contain the word 'select', 'insert', 'update' or 'delete':
select null
from pqh_copy_entity_results a
where a.copy_entity_txn_id = p_copy_entity_txn_id
and a.result_type_cd = 'TARGET'
and a.status = 'COMPLETED' ;
select null
from pqh_txn_category_attributes a
where a.txn_category_attribute_id = p_txn_category_attribute_id;
select null
from per_business_groups a
where a.business_group_id = p_context_business_group_id;
select null
from pqh_transaction_categories a
where a.transaction_category_id = p_transaction_category_id;
Procedure insert_validate(p_rec in pqh_cet_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_cet_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_cet_shd.g_rec_type
,p_effective_date in date) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;