The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
segment9 /* account name */
into
l_in_account_name
from
pay_external_accounts
where
external_account_id = p_external_account_id;
procedure chk_account_name_update
(
p_external_account_id in number,
p_external_account_id_o in number
) is
begin
--
if nvl(p_external_account_id, hr_api.g_number) <> nvl(p_external_account_id_o, hr_api.g_number) then
--
chk_account_name(p_external_account_id);
end chk_account_name_update;
procedure chk_swot_account_name_update
(
p_org_information_context in varchar2,
p_org_information17 in varchar2,
p_org_information17_o in varchar2
) is
begin
--
if nvl(p_org_information17, hr_api.g_varchar2) <> nvl(p_org_information17_o, hr_api.g_varchar2) then
--
chk_swot_account_name(p_org_information_context, p_org_information17);
end chk_swot_account_name_update;