APPS.OE_CUSTOMER_INFO_PVT dependencies on HZ_CUST_ACCT_SITES

Line 2279: FROM hz_cust_acct_sites

2275: x_cust_acct_site_id := FND_API.G_MISS_NUM;
2276:
2277: SELECT cust_acct_site_id
2278: INTO x_cust_acct_site_id
2279: FROM hz_cust_acct_sites
2280: WHERE party_site_id = p_party_site_id
2281: AND cust_account_id = p_cust_account_id
2282: AND ROWNUM =1;
2283:

Line 2314: FROM hz_cust_acct_sites acct_site,

2310:
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

Line 3228: hz_cust_acct_sites acct_site,

3224:
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

Line 3833: FROM hz_cust_acct_sites acct_site,

3829: x_site_use_id := FND_API.G_MISS_NUM;
3830:
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