APPS.CS_CHARGE_CORE_PVT dependencies on HZ_CUST_ACCT_SITES

Line 279: hz_cust_acct_sites a

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
283: AND a.cust_account_id = l_cust_id;

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;