APPS.ARP_CMERGE_ARCPF dependencies on HZ_CUST_ACCOUNTS

Line 130: FROM hz_cust_accounts acct

126: AND m.delete_duplicate_flag = 'Y'
127: AND site_use_id IS NULL
128: AND NOT EXISTS (
129: SELECT 'accounts exist'
130: FROM hz_cust_accounts acct
131: WHERE acct.cust_account_id = yt.customer_id
132: AND acct.status <> 'D' )
133: FOR UPDATE NOWAIT;
134:

Line 184: FROM hz_cust_accounts acct

180: AND m.delete_duplicate_flag = 'Y' )
181: AND site_use_id IS NULL
182: AND NOT EXISTS (
183: SELECT 'accounts exist'
184: FROM hz_cust_accounts acct
185: WHERE acct.cust_account_id = yt.customer_id
186: AND acct.status <> 'D' );
187:
188: g_count := sql%rowcount;

Line 260: FROM hz_cust_accounts acct

256: AND m.delete_duplicate_flag = 'N'
257: AND site_use_id IS NULL
258: AND NOT EXISTS (
259: SELECT 'active accounts exist'
260: FROM hz_cust_accounts acct
261: WHERE acct.cust_account_id = yt.cust_account_id
262: AND acct.status = 'A')
263: FOR UPDATE NOWAIT;
264:

Line 277: FROM hz_cust_accounts acct

273: AND m.delete_duplicate_flag = 'Y'
274: AND site_use_id IS NULL
275: AND NOT EXISTS (
276: SELECT 'accounts exist'
277: FROM hz_cust_accounts acct
278: WHERE acct.cust_account_id = yt.cust_account_id
279: AND acct.status <> 'D' )
280: FOR UPDATE NOWAIT;
281:

Line 353: FROM hz_cust_accounts acct

349: AND m.delete_duplicate_flag = 'N' )
350: AND site_use_id IS NULL
351: AND NOT EXISTS (
352: SELECT 'active accounts exist'
353: FROM hz_cust_accounts acct
354: WHERE acct.cust_account_id = yt.cust_account_id
355: AND acct.status = 'A');
356:
357: g_count := sql%rowcount;

Line 401: FROM hz_cust_accounts acct

397: AND m.delete_duplicate_flag = 'Y' )
398: AND site_use_id IS NULL
399: AND NOT EXISTS (
400: SELECT 'accounts exist'
401: FROM hz_cust_accounts acct
402: WHERE acct.cust_account_id = yt.cust_account_id
403: AND acct.status <> 'D' );
404:
405: g_count := sql%rowcount;

Line 480: FROM hz_cust_accounts acct

476: AND m.delete_duplicate_flag = 'N'
477: AND site_use_id IS NULL
478: AND NOT EXISTS (
479: SELECT 'active accounts exist'
480: FROM hz_cust_accounts acct
481: WHERE acct.cust_account_id = yt.cust_account_id
482: AND acct.status = 'A')
483: FOR UPDATE NOWAIT;
484:

Line 551: FROM hz_cust_accounts acct

547: AND m.delete_duplicate_flag = 'N' )
548: AND site_use_id IS NULL
549: AND NOT EXISTS (
550: SELECT 'active accounts exist'
551: FROM hz_cust_accounts acct
552: WHERE acct.cust_account_id = yt.cust_account_id
553: AND acct.status = 'A') ;
554:
555: g_count := sql%rowcount;

Line 717: FROM hz_cust_accounts acct

713: AND m.delete_duplicate_flag = 'Y' )
714: AND site_use_id IS NULL
715: AND NOT EXISTS (
716: SELECT 'accounts exist'
717: FROM hz_cust_accounts acct
718: WHERE acct.cust_account_id = yt.cust_account_id
719: AND acct.status <> 'D' );
720:
721: g_count := sql%rowcount;