APPS.CSD_RETURNS_UTIL dependencies on HZ_PARTY_SITE_USES

Line 685: FROM hz_party_site_uses

681: l_cust_acct_site_rec.cust_account_id := p_account_id;
682:
683: SELECT party_site_id
684: INTO l_cust_acct_site_rec.party_site_id
685: FROM hz_party_site_uses
686: WHERE party_site_use_id = p_bill_to_site_use_id;
687:
688: l_cust_acct_site_rec.status := 'A';
689: l_cust_acct_site_rec.created_by_module := 'CSDSR';

Line 2276: FROM hz_party_site_uses bill, hz_party_site_uses ship

2272:
2273: -- get the bill to site and ship to site ids.
2274: SELECT bill.party_site_id, ship.party_site_id
2275: INTO l_bill_to_site_id, l_ship_to_site_id
2276: FROM hz_party_site_uses bill, hz_party_site_uses ship
2277: WHERE bill.party_site_use_id = p_bill_to_addr_use_id
2278: AND ship.party_site_use_id = p_ship_to_addr_use_id;
2279:
2280: -- submit a request to create the logistics lines.