APPS.IEX_AGING_BUCKETS_PKG dependencies on HZ_CUST_SITE_USES

Line 1220: hz_cust_site_uses hzsu,

1216: -app.acctd_amount_applied_from,
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

Line 1419: hz_cust_site_uses_all site_uses,

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
1423: /* bug no : 1274152. Aging form did not consider the receipts done