46: g_acctnum_list.DELETE;
47:
48: FOR CUST IN (SELECT distinct m.customer_id, acct.account_number
49: FROM ra_customer_merges m
50: , hz_cust_accounts acct
51: WHERE m.set_number = p_set_num
52: AND m.request_id = p_request_id
53: AND m.process_flag = 'N'
54: AND acct.cust_account_id = m.customer_id