APPS.CS_CHARGE_CORE_PVT dependencies on HZ_CUST_SITE_USES

Line 278: FROM hz_cust_site_uses b,

274: WHERE incident_id = p_qte_header_id;
275:
276: CURSOR C_site_use(l_cust_id NUMBER, l_ship_site_id NUMBER) IS
277: SELECT site_use_id
278: FROM hz_cust_site_uses b,
279: hz_cust_acct_sites a
280: WHERE b.cust_acct_site_id = a.cust_acct_site_id
281: AND b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
282: AND a.party_site_id = l_ship_site_id

Line 300: -- Get the site use id from the HZ_cust_site_uses

296: OPEN c_cust_id;
297: FETCH c_cust_id INTO l_cust_id;
298: CLOSE c_cust_id;
299:
300: -- Get the site use id from the HZ_cust_site_uses
301:
302: OPEN C_site_use(l_cust_id , l_ship_site_id);
303: FETCH C_site_use into l_ship_site_use_id;
304: CLOSE C_site_use;

Line 319: -- Get the site use id from the HZ_cust_site_uses

315: OPEN c_cust_id;
316: FETCH c_cust_id INTO l_cust_id;
317: CLOSE c_cust_id;
318:
319: -- Get the site use id from the HZ_cust_site_uses
320:
321: OPEN C_site_use(l_cust_id , l_ship_site_id);
322: FETCH C_site_use into l_ship_site_use_id;
323: CLOSE C_site_use;

Line 362: FROM hz_cust_site_uses b,hz_cust_acct_sites a

358: WHERE incident_id = p_qte_header_id;
359:
360: CURSOR C_site_use(l_cust_id NUMBER, l_inv_site_id NUMBER) IS
361: SELECT site_use_id
362: FROM hz_cust_site_uses b,hz_cust_acct_sites a
363: WHERE b.cust_acct_site_id = a.cust_acct_site_id
364: AND b.site_use_code = 'BILL_TO'
365: AND a.party_site_id = l_inv_site_id
366: AND a.cust_account_id = l_cust_id;

Line 382: -- Get the site use id from the HZ_cust_site_uses

378: OPEN c_cust_id;
379: FETCH c_cust_id INTO l_cust_id;
380: CLOSE c_cust_id;
381:
382: -- Get the site use id from the HZ_cust_site_uses
383:
384: OPEN C_site_use(l_cust_id , l_inv_site_id);
385: FETCH C_site_use into l_bill_site_use_id;
386: CLOSE C_site_use;

Line 401: -- Get the site use id from the HZ_cust_site_uses

397: OPEN c_cust_id;
398: FETCH c_cust_id INTO l_cust_id;
399: CLOSE c_cust_id;
400:
401: -- Get the site use id from the HZ_cust_site_uses
402:
403: OPEN C_site_use(l_cust_id , l_inv_site_id);
404: FETCH C_site_use into l_bill_site_use_id;
405: CLOSE C_site_use;