DBA Data[Home] [Help]

APPS.OKC_XPRT_OM_INT_PVT dependencies on HZ_CUST_ACCT_SITES

Line 304: hz_cust_acct_sites cas,

300: loc.country
301: FROM
302: hz_locations loc,
303: hz_party_sites ps,
304: hz_cust_acct_sites cas,
305: hz_cust_site_uses su
306: WHERE
307: ps.location_id = loc.location_id
308: and cas.party_site_id = ps.party_site_id

Line 333: hz_cust_acct_sites cas,

329: loc.county
330: FROM
331: hz_locations loc,
332: hz_party_sites ps,
333: hz_cust_acct_sites cas,
334: hz_cust_site_uses su
335: WHERE
336: ps.location_id = loc.location_id
337: and cas.party_site_id = ps.party_site_id

Line 348: hz_cust_acct_sites cas,

344: CURSOR c_get_cust_account(p_site_use_id NUMBER) IS
345: SELECT
346: cas.cust_account_id
347: FROM
348: hz_cust_acct_sites cas,
349: hz_cust_site_uses su
350: WHERE
351: su.cust_acct_site_id = cas.cust_acct_site_id
352: and su.site_use_id = p_site_use_id;