APPS.AR_LATE_CHARGE_PKG dependencies on HZ_CUST_SITE_USES

Line 1925: log( message => 'Updating hz_cust_site_uses for adjustment in Success');

1921: AND DECODE(p_worker_num,NULL,NVL(a.worker_num,-9),p_worker_num)=NVL(a.worker_num,-9);
1922:
1923:
1924: --{Update the last_accrue_date for customer account site uses
1925: log( message => 'Updating hz_cust_site_uses for adjustment in Success');
1926: UPDATE hz_cust_site_uses
1927: SET LAST_ACCRUE_CHARGE_DATE = s_cal_int_date
1928: WHERE SITE_USE_ID IN
1929: (SELECT DISTINCT customer_site_use_id

Line 1926: UPDATE hz_cust_site_uses

1922:
1923:
1924: --{Update the last_accrue_date for customer account site uses
1925: log( message => 'Updating hz_cust_site_uses for adjustment in Success');
1926: UPDATE hz_cust_site_uses
1927: SET LAST_ACCRUE_CHARGE_DATE = s_cal_int_date
1928: WHERE SITE_USE_ID IN
1929: (SELECT DISTINCT customer_site_use_id
1930: FROM ar_interest_headers h