DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 260: hz_cust_acct_sites cas,

256: loc.country
257: FROM
258: hz_locations loc,
259: hz_party_sites ps,
260: hz_cust_acct_sites cas,
261: hz_cust_site_uses su
262: WHERE
263: ps.location_id = loc.location_id
264: and cas.party_site_id = ps.party_site_id

Line 276: hz_cust_acct_sites cas,

272: CURSOR c_get_cust_account(p_site_use_id NUMBER) IS
273: SELECT
274: cas.cust_account_id
275: FROM
276: hz_cust_acct_sites cas,
277: hz_cust_site_uses su
278: WHERE
279: su.cust_acct_site_id = cas.cust_acct_site_id
280: and su.site_use_id = p_site_use_id;