APPS.IEX_AGING_BUCKETS_PKG dependencies on HZ_CUST_ACCT_SITES

Line 1221: hz_cust_acct_sites hzas

1217: -app.amount_applied),0), 0) ), 0)
1218: FROM ar_receivable_applications app,
1219: ar_payment_schedules ps,
1220: hz_cust_site_uses hzsu,
1221: hz_cust_acct_sites hzas
1222: WHERE ps.customer_id = hzas.cust_account_id
1223: and hzsu.cust_acct_site_id = hzas.cust_acct_site_id
1224: AND hzsu.site_use_id = ps.customer_site_use_id
1225: AND ps.cash_receipt_id = app.cash_receipt_id

Line 1418: hz_cust_acct_sites_all acct_site,

1414: crh.amount)), 0)
1415: FROM ar_cash_receipts cr,
1416: ar_cash_receipt_history crh,
1417: /* begin add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1418: hz_cust_acct_sites_all acct_site,
1419: hz_cust_site_uses_all site_uses,
1420: hz_cust_accounts_all cust_acct
1421: /* end add for bug 4930373 to use AR_CASH_RECEIPTS_N2 */
1422: WHERE cr.customer_site_use_id = p_filter_id