APPS.GMS_AWARD_PVT dependencies on HZ_CUST_SITE_USES

Line 242: hz_cust_site_uses su

238: SELECT 'X'
239: FROM Hz_party_sites party_site,
240: Hz_locations loc,
241: Hz_cust_acct_sites_all acct_site,
242: hz_cust_site_uses su
243: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
244: AND acct_site.party_site_id = party_site.party_site_id
245: AND loc.location_id = party_site.location_id
246: AND acct_site.cust_account_id = p_customer_id

Line 306: Hz_cust_site_uses su

302: su.Contact_Id
303: FROM hz_cust_acct_sites_all acct_site,
304: hz_party_sites party_site,
305: hz_locations loc,
306: Hz_cust_site_uses su
307: Where acct_site.cust_acct_site_id = su.cust_acct_site_id
308: And acct_site.cust_account_id = l_Customer_Id
309: And acct_site.party_site_id = party_site.party_site_id
310: And loc.location_id = party_site.location_id

Line 4347: FROM hz_cust_site_uses a,

4343:
4344:
4345: CURSOR l_valid_usage_csr IS
4346: SELECT 'X'
4347: FROM hz_cust_site_uses a,
4348: Hz_cust_acct_sites b,
4349: ar_lookups c,
4350: gms_awards_all ga
4351: WHERE a.cust_acct_site_id = b.cust_acct_site_id

Line 4627: FROM hz_cust_site_uses a,

4623: AND lookup_code = G_report_rec.frequency;
4624:
4625: CURSOR l_valid_site_code_csr IS
4626: SELECT 'X'
4627: FROM hz_cust_site_uses a,
4628: Hz_cust_acct_sites b,
4629: ar_lookups c,
4630: gms_awards_all d
4631: WHERE a.cust_acct_site_id = b. cust_acct_site_id