APPS.AR_LATE_CHARGE_PKG dependencies on HZ_CUST_SITE_USES

Line 1235: /*10297326 add join with hz_cust_site uses to get contact id*/

1231: p_exec_status IN VARCHAR2 DEFAULT 'I',
1232: p_clear_iv IN VARCHAR2 DEFAULT 'Y',
1233: x_nb_row OUT NOCOPY NUMBER)
1234: IS
1235: /*10297326 add join with hz_cust_site uses to get contact id*/
1236: CURSOR get_read_a_header IS
1237: SELECT
1238: lgt.interest_header_id ,
1239: lgt.CURRENCY_CODE ,

Line 1272: hz_cust_site_uses_all su

1268: lgt.gl_id_rev,
1269: su.contact_id,
1270: su.cust_acct_site_id
1271: FROM ar_late_charge_doc_gt lgt,
1272: hz_cust_site_uses_all su
1273: WHERE interest_header_id = p_header_id
1274: AND interest_batch_id = g_interest_batch_id
1275: AND execution_status = p_exec_status
1276: AND header_type IN ('INV','DM')

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

1961: AND DECODE(p_worker_num,NULL,NVL(a.worker_num,-9),p_worker_num)=NVL(a.worker_num,-9);
1962:
1963:
1964: --{Update the last_accrue_date for customer account site uses
1965: log( message => 'Updating hz_cust_site_uses for adjustment in Success');
1966: UPDATE hz_cust_site_uses
1967: SET LAST_ACCRUE_CHARGE_DATE = s_cal_int_date
1968: WHERE SITE_USE_ID IN
1969: (SELECT DISTINCT customer_site_use_id

Line 1966: UPDATE hz_cust_site_uses

1962:
1963:
1964: --{Update the last_accrue_date for customer account site uses
1965: log( message => 'Updating hz_cust_site_uses for adjustment in Success');
1966: UPDATE hz_cust_site_uses
1967: SET LAST_ACCRUE_CHARGE_DATE = s_cal_int_date
1968: WHERE SITE_USE_ID IN
1969: (SELECT DISTINCT customer_site_use_id
1970: FROM ar_interest_headers h