DBA Data[Home] [Help]

APPS.OZF_CLAIM_UTILITY_PVT dependencies on HZ_CUST_ACCT_RELATE_ALL

Line 677: FROM HZ_CUST_ACCT_RELATE_ALL REL, HZ_CUST_ACCT_SITES_ALL ACCT_SITE,

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

Line 750: FROM HZ_CUST_ACCT_RELATE_ALL REL,

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