DBA Data[Home] [Help]

APPS.OKL_ARINTF_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1367: FROM hz_cust_acct_sites_all a,

1363: AND inst.cle_id = p_kle_top_line;
1364:
1365: CURSOR Ship_to_csr2( p_customer_num NUMBER, p_install_location NUMBER, p_location NUMBER, p_org_id NUMBER ) IS
1366: SELECT a.CUST_ACCT_SITE_ID
1367: FROM hz_cust_acct_sites_all a,
1368: hz_cust_site_uses_all b,
1369: hz_party_sites c
1370: WHERE a.CUST_ACCT_SITE_ID = b.CUST_ACCT_SITE_ID AND
1371: b.site_use_code = 'SHIP_TO' AND