167:
168: -- get customer account number
169: CURSOR c_get_cust_acct_num (c_acct_id IN NUMBER) IS
170: SELECT account_number
171: FROM hz_cust_accounts
172: WHERE cust_account_id = c_acct_id;
173:
174: i NUMBER := 0;
175:
877:
878: -- get customer account number
879: CURSOR c_get_cust_acct_num (c_acct_id IN NUMBER) IS
880: SELECT account_number
881: FROM hz_cust_accounts
882: WHERE cust_account_id = c_acct_id;
883:
884: -----------------
885: --cursor for getting old messages