DBA Data[Home] [Help]

APPS.JTF_TASK_CUST_MERGE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 50: , hz_cust_accounts acct

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