APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_PARTY_SITES

Line 2175: FROM hz_party_sites

2171: ) IS
2172: CURSOR party_location
2173: IS
2174: SELECT party_site_id,location_id
2175: FROM hz_party_sites
2176: WHERE party_id = p_party_id;
2177:
2178: l_location_rec HZ_LOCATION_V2PUB.location_rec_type;
2179: l_return_status VARCHAR2(1);

Line 2315: hz_party_sites party_site,

2311:
2312: SELECT loc.location_id
2313: INTO l_location_id
2314: FROM hz_cust_acct_sites acct_site,
2315: hz_party_sites party_site,
2316: hz_locations loc
2317: WHERE acct_site.party_site_id = party_site.party_site_id
2318: AND loc.location_id = party_site.location_id
2319: AND acct_site.cust_acct_site_id = p_cust_acct_site_id ;

Line 3229: hz_party_sites party_site,

3225: SELECT loc.location_id
3226: INTO l_location_id
3227: FROM hz_cust_site_uses site_uses,
3228: hz_cust_acct_sites acct_site,
3229: hz_party_sites party_site,
3230: hz_locations loc
3231: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
3232: AND acct_site.party_site_id = party_site.party_site_id
3233: AND loc.location_id = party_site.location_id

Line 3835: hz_party_sites party_site,

3831: SELECT site_uses.site_use_id
3832: INTO x_site_use_id
3833: FROM hz_cust_acct_sites acct_site,
3834: hz_cust_site_uses site_uses,
3835: hz_party_sites party_site,
3836: hz_locations loc
3837: WHERE site_uses.cust_acct_site_id = acct_site.cust_acct_site_id
3838: AND acct_site.party_site_id = party_site.party_site_id
3839: AND loc.location_id = party_site.location_id