APPS.ARP_CMERGE_MASTER dependencies on HZ_CUST_ACCOUNTS

Line 2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/

2390: AND part_delete = 'N'; --5747129
2391:
2392: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2393:
2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),
2397: last_update_date = sysdate,
2398: last_updated_by = hz_utility_v2pub.user_id,

Line 2395: UPDATE HZ_CUST_ACCOUNTS acct

2391:
2392: arp_message.set_line(SQL%ROWCOUNT||' '||'Row(s) updated in HZ_CUST_ACCT_SITES');
2393:
2394: /*--Unset the status to 'I' for HZ_CUST_ACCOUNTS which was set to 'D'*/
2395: UPDATE HZ_CUST_ACCOUNTS acct
2396: set status = decode(part_delete,'N','I','A'),
2397: last_update_date = sysdate,
2398: last_updated_by = hz_utility_v2pub.user_id,
2399: last_update_login = hz_utility_v2pub.last_update_login,

Line 2407: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCOUNTS');

2403: program_update_date = sysdate
2404: where acct.cust_account_id = from_customer_id
2405: and status ='D';
2406:
2407: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in HZ_CUST_ACCOUNTS');
2408:
2409: /*--Unset the status to 'I' for HZ_CUST_ACCT_RELATE cust_account_id */
2410: UPDATE HZ_CUST_ACCT_RELATE_ALL rel
2411: SET status = 'I',

Line 2480: FROM hz_cust_accounts acct

2476: AND m.delete_duplicate_flag = 'N' )
2477: AND site_use_id IS NULL
2478: AND NOT EXISTS (
2479: SELECT 'active accounts exist'
2480: FROM hz_cust_accounts acct
2481: WHERE acct.cust_account_id = yt.customer_id
2482: AND acct.status = 'A' );
2483:
2484: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');