APPS.OZF_SD_REQUEST_PUB dependencies on HZ_CUST_SITE_USES

Line 1855: FROM hz_cust_site_uses sites,

1851: ,p_party_id IN NUMBER
1852: ,p_site_use_id IN NUMBER
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