APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on RA_CUSTOMER_TRX_ALL

Line 816: FROM ra_customer_trx_all trx1, ra_cust_trx_types_all type1

812: AND (ac.vat_tax_id = P_TAX_RATE_ID OR P_TAX_RATE_ID IS NULL)
813: AND ( (aa.status = 'ACC')
814: OR (aa.applied_customer_trx_id IN(
815: SELECT trx1.customer_trx_id
816: FROM ra_customer_trx_all trx1, ra_cust_trx_types_all type1
817: WHERE trx1.cust_trx_type_id = type1.cust_trx_type_id
818: AND trx1.org_id = type1.org_id
819: AND type1.type ='DEP' ) ) )
820: AND (ac.receipt_date between