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:
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;
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:
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:
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;
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;
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:
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;
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;