235: --Bug : 3455542 : Added by Sanjay Banerjee
236: --Rewriting the cursor to use HZ tables instead of RA Tables :TCA Changes
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
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
308: And acct_site.cust_account_id = l_Customer_Id