APPS.PAY_PL_PERSONAL_PAY_METHOD SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 50

PROCEDURE UPDATE_PL_PERSONAL_PAY_METHOD
(p_segment1 varchar2
,p_segment2 varchar2
,p_segment3 varchar2
,p_segment12 varchar2
,p_personal_payment_method_id number
) is
p_var number;

Line: 67

cursor p_cur1 is select segment1,segment2,segment3,segment12  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 );

Line: 74

   hr_utility.trace('PL not installed.Leaving UPDATE_PL_PERSONAL_PAY_METHOD');

Line: 136

end UPDATE_PL_PERSONAL_PAY_METHOD;