DBA Data[Home] [Help]

APPS.OZF_CLAIM_TAX_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 156: FROM hz_cust_site_uses_all cust_site_use,

152:
153: CURSOR csr_cust_party_details(p_cust_acct_site_use_id IN NUMBER) IS
154: SELECT party_site.party_site_id,
155: party_site.location_id
156: FROM hz_cust_site_uses_all cust_site_use,
157: hz_cust_acct_sites_all cust_site,
158: hz_party_sites party_site
159: WHERE site_use_id = p_cust_acct_site_use_id
160: AND cust_site.cust_acct_site_id = cust_site_use.cust_acct_site_id