APPS.ASO_SHIPMENT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 264: FROM hz_cust_site_uses b,hz_cust_acct_sites a

260: WHERE quote_header_id = p_qte_header_id;
261:
262: CURSOR C_site_use(l_cust_id NUMBER, l_inv_site_id NUMBER) IS
263: SELECT site_use_id
264: FROM hz_cust_site_uses b,hz_cust_acct_sites a
265: WHERE b.cust_acct_site_id = a.cust_acct_site_id
266: AND b.site_use_code = 'BILL_TO' --and b.primary_flag = 'Y'
267: AND a.party_site_id = l_inv_site_id
268: AND a.cust_account_id = l_cust_id;

Line 508: FROM hz_cust_site_uses b,hz_cust_acct_sites a

504: and quote_line_id IS NULL;
505:
506: CURSOR C_site_use(l_cust_id NUMBER, l_ship_site_id NUMBER) IS
507: SELECT site_use_id
508: FROM hz_cust_site_uses b,hz_cust_acct_sites a
509: WHERE b.cust_acct_site_id = a.cust_acct_site_id
510: AND b.site_use_code = 'SHIP_TO' --and b.primary_flag = 'Y'
511: AND a.party_site_id = l_ship_site_id
512: AND a.cust_account_id = l_cust_id;