APPS.ARP_CMERGE_MASTER dependencies on RA_CUST_RECEIPT_METHODS

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

2452: AND part_delete = 'N'; --5747129
2453:
2454: arp_message.set_line( SQL%ROWCOUNT||' '|| 'Rows updated in HZ_CUST_ACCT_RELATE for related_cust_account_id' );
2455:
2456: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2457: *--not required at site level as all the site uses get merged for an acct
2458: *--delete is prevented by delete_duplicate_flag='N' */
2459:
2460: UPDATE RA_CUST_RECEIPT_METHODS yt

Line 2460: UPDATE RA_CUST_RECEIPT_METHODS yt

2456: /*--unset the end_date of RA_CUST_RECEIPT_METHODS at account level
2457: *--not required at site level as all the site uses get merged for an acct
2458: *--delete is prevented by delete_duplicate_flag='N' */
2459:
2460: UPDATE RA_CUST_RECEIPT_METHODS yt
2461: set end_date = null,
2462: last_update_date = sysdate,
2463: last_updated_by = hz_utility_v2pub.user_id,
2464: last_update_login = hz_utility_v2pub.last_update_login,

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

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');
2485:
2486: /* ---Unset status to Inactive for HZ_CUSTOMER_PROFILES for both
2487: * ---acct and site level */
2488: UPDATE hz_customer_profiles yt