APPS.OZF_SD_REQUEST_PUB dependencies on HZ_PARTY_SITES

Line 1857: hz_party_sites party_sites

1853: ,p_site_use_code IN VARCHAR2)IS
1854: SELECT sites.site_use_id
1855: FROM hz_cust_site_uses sites,
1856: hz_cust_acct_sites acct_sites,
1857: hz_party_sites party_sites
1858: WHERE sites.cust_acct_site_id = acct_sites.cust_acct_site_id
1859: AND acct_sites.party_site_id = party_sites.party_site_id
1860: AND acct_sites.cust_account_id = p_cust_account_id
1861: AND party_sites.party_id = p_party_id