The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UPDATE_PL_PERSONAL_PAY_METHOD
(p_segment1 varchar2
,p_segment2 varchar2
,p_segment3 varchar2
,p_personal_payment_method_id number
) is
p_var number;
cursor p_cur1 is select segment1,segment2,segment3 from pay_external_accounts where external_account_id =
(select external_Account_id from pay_personal_payment_methods_f where personal_payment_method_id = p_personal_payment_method_id );
hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSONAL_PAY_METHOD');
end UPDATE_PL_PERSONAL_PAY_METHOD;