APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on HZ_CUST_ACCOUNTS

Line 827: hz_cust_accounts rc

823: OR aa.cash_receipt_id IN
824: ( SELECT distinct a1.cash_receipt_id
825: FROM ar_receivable_applications_all a1,
826: ar_receivable_applications_all a2,
827: hz_cust_accounts rc
828: WHERE
829: DECODE(SIGN(a1.amount_applied),-1,a1.gl_date,a1.gl_date) BETWEEN
830: NVL(TO_DATE(P_GL_PERIOD_START_DATE,'DD-MM-YYYY'),TO_DATE('01-01-1890','DD-MM-YYYY'))
831: AND nvl(TO_DATE(P_GL_PERIOD_END_DATE,'DD-MM-YYYY'), TO_DATE('30-12-2199','DD-MM-YYYY'))

Line 863: hz_cust_accounts rc,

859: FROM ar_receivable_applications_all aa,
860: zx_rates_b at,
861: ar_cash_receipts_all ac,
862: ra_customer_trx tr,
863: hz_cust_accounts rc,
864: hz_parties hzp,
865: hz_cust_acct_sites cs,
866: hz_cust_site_uses csu
867: WHERE aa.applied_customer_trx_id = tr.customer_trx_id