673: ra_cust_trx_types_all ctt,
674: ra_customer_trx_all ct,
675: (
676: SELECT SITE.site_use_id site_use_id
677: FROM HZ_CUST_ACCT_RELATE_ALL REL, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
678: HZ_CUST_SITE_USES_ALL SITE
679: WHERE
680: REL.status = 'A'
681: AND REL.cust_account_id = p_cust_account_id --cust_account_id from deduction
746: ra_cust_trx_types_all ctt,
747: ra_customer_trx_all ct,
748: (
749: SELECT SITE.site_use_id site_use_id
750: FROM HZ_CUST_ACCT_RELATE_ALL REL,
751: HZ_CUST_ACCT_SITES_ALL ACCT_SITE,
752: HZ_CUST_SITE_USES_ALL SITE
753: WHERE REL.status = 'A'
754: AND REL.cust_account_id = p_cust_account_id --cust_account_id from deduction