319: PROCEDURE awt_before_report IS
320: CURSOR c_methods IS
321: SELECT UPPER(accounting_method_option),
322: UPPER(secondary_accounting_method)
323: FROM ap_system_parameters;
324: first_acct_method ap_system_parameters.accounting_method_option%TYPE;
325: second_acct_method ap_system_parameters.secondary_accounting_method%TYPE;
326:
327: BEGIN
320: CURSOR c_methods IS
321: SELECT UPPER(accounting_method_option),
322: UPPER(secondary_accounting_method)
323: FROM ap_system_parameters;
324: first_acct_method ap_system_parameters.accounting_method_option%TYPE;
325: second_acct_method ap_system_parameters.secondary_accounting_method%TYPE;
326:
327: BEGIN
328: OPEN c_methods;
321: SELECT UPPER(accounting_method_option),
322: UPPER(secondary_accounting_method)
323: FROM ap_system_parameters;
324: first_acct_method ap_system_parameters.accounting_method_option%TYPE;
325: second_acct_method ap_system_parameters.secondary_accounting_method%TYPE;
326:
327: BEGIN
328: OPEN c_methods;
329: FETCH c_methods INTO first_acct_method, second_acct_method;