APPS.ARP_CMERGE_MASTER dependencies on RA_CUST_RECEIPT_METHODS

Line 2449: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level

2445: AND part_delete = 'N'; --5747129
2446:
2447: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Rows updated in HZ_CUST_ACCT_RELATE for related_cust_account_id' );
2448:
2449: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2450: *--not required at site level as all the site uses get merged for an acct
2451: *--delete is prevented by delete_duplicate_flag='N' */
2452:
2453: UPDATE RA_CUST_RECEIPT_METHODS yt

Line 2453: UPDATE RA_CUST_RECEIPT_METHODS yt

2449: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2450: *--not required at site level as all the site uses get merged for an acct
2451: *--delete is prevented by delete_duplicate_flag='N' */
2452:
2453: UPDATE RA_CUST_RECEIPT_METHODS yt
2454: set end_date = null,
2455: last_update_date = sysdate,
2456: last_updated_by = hz_utility_v2pub.user_id,
2457: last_update_login = hz_utility_v2pub.last_update_login,

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

2473: FROM hz_cust_accounts acct
2474: WHERE acct.cust_account_id = yt.customer_id
2475: AND acct.status = 'A' );
2476:
2477: arp_message.set_line(SQL%ROWCOUNT||' '|| 'Row(s) updated in RA_CUST_RECEIPT_METHODS');
2478:
2479: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2480: * ---acct and site level */
2481: UPDATE hz_customer_profiles yt