APPS.GMS_AWARD_PVT dependencies on HZ_CUST_ACCT_SITES

Line 241: Hz_cust_acct_sites_all acct_site,

237: CURSOR C_verify_con_exists(p_customer_id number) IS
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

Line 303: FROM hz_cust_acct_sites_all acct_site,

299: --TCA Enhancement : Replaced ra_address_all, ra_site_uses
300: CURSOR C_cust_info is
301: SELECT acct_site.cust_acct_site_id,
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

Line 4348: Hz_cust_acct_sites b,

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
4352: AND b.cust_account_id = decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)

Line 4628: Hz_cust_acct_sites b,

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
4632: AND b. cust_account_id = d.funding_source_id