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 4346: Hz_cust_acct_sites b,

4342:
4343: CURSOR l_valid_usage_csr IS
4344: SELECT 'X'
4345: FROM hz_cust_site_uses a,
4346: Hz_cust_acct_sites b,
4347: ar_lookups c,
4348: gms_awards_all ga
4349: WHERE a.cust_acct_site_id = b.cust_acct_site_id
4350: AND b.cust_account_id = decode(ga.billing_format,'LOC',ga.bill_to_customer_id,ga.funding_source_id)

Line 4626: Hz_cust_acct_sites b,

4622:
4623: CURSOR l_valid_site_code_csr IS
4624: SELECT 'X'
4625: FROM hz_cust_site_uses a,
4626: Hz_cust_acct_sites b,
4627: ar_lookups c,
4628: gms_awards_all d
4629: WHERE a.cust_acct_site_id = b. cust_acct_site_id
4630: AND b. cust_account_id = d.funding_source_id