The following lines contain the word 'select', 'insert', 'update' or 'delete':
Procedure insert_validate
(
p_rec in out nocopy ota_tfh_api_shd.g_rec_type
,p_transaction_type in varchar2
) is
--
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
Procedure update_validate(p_rec in out nocopy ota_tfh_api_shd.g_rec_type
,p_transaction_type in varchar2) is
--
l_proc varchar2(72) := g_package||'update_validate';
ota_tfh_api_business_rules.check_update_header
( ota_tfh_api_shd.g_old_rec
, p_rec
, p_transaction_type);
ota_tfh_api_business_rules.check_update_customer_id
( p_rec.customer_id
, p_rec.address_id
, p_rec.contact_id
, p_rec.vendor_id );
End update_validate;
Procedure delete_validate(p_rec in ota_tfh_api_shd.g_rec_type) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;
select pbg.security_group_id,
pbg.legislation_code
from per_business_groups_perf pbg,
ota_finance_headers tfh,
hr_all_organization_units org
where pbg.business_group_id = org.business_group_id
and org.organization_id = tfh.organization_id
and tfh.finance_header_id = p_finance_header_id;
select legislation_code
from per_business_groups_perf pbg,
ota_finance_headers tfh,
hr_all_organization_units org
where pbg.business_group_id = org.business_group_id
and org.organization_id = tfh.organization_id
and tfh.finance_header_id = p_finance_header_id;