APPS.FV_SLA_AR_PROCESSING_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 233: hz_cust_site_uses_all hcsu,

229: INTO p_org_id,
230: p_rec_atrribute_id,
231: p_customer_id
232: FROM ar_cash_receipts_all h,
233: hz_cust_site_uses_all hcsu,
234: hz_cust_acct_sites_all hcas
235: WHERE h.cash_receipt_id = p_transcation_id
236: AND hcsu.site_use_id = h.customer_site_use_id
237: AND hcas.cust_acct_site_id = hcsu.cust_acct_site_id;

Line 300: hz_cust_site_uses_all hcsu,

296: p_rec_atrribute_id,
297: p_customer_id
298: FROM ar_adjustments_all h,
299: ar_cash_receipts_all acr,
300: hz_cust_site_uses_all hcsu,
301: hz_cust_acct_sites_all hcas
302: WHERE h.adjustment_id = p_transcation_id
303: AND h.associated_cash_receipt_id = acr.cash_receipt_id
304: AND hcsu.site_use_id = acr.customer_site_use_id

Line 316: hz_cust_site_uses_all hcsu,

312: p_rec_atrribute_id,
313: p_customer_id
314: FROM ar_adjustments_all h,
315: ra_customer_trx_all acr,
316: hz_cust_site_uses_all hcsu,
317: hz_cust_acct_sites_all hcas
318: WHERE h.adjustment_id = p_transcation_id
319: AND h.customer_trx_id = acr.customer_trx_id
320: AND hcsu.site_use_id = acr.bill_to_site_use_id