DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 771: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,

767:
768: CURSOR l_lang_territory_csr (p_trxnmid IN NUMBER) IS
769: SELECT loc.language, loc.country
770: FROM hz_party_sites ps, hz_locations loc,
771: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,
772: hz_cust_acct_sites_all hz_cs
773: where txn.trxnmid = p_trxnmid
774: and hz_csu.cust_acct_site_id = hz_cs.cust_acct_site_id
775: and hz_cs.party_site_id = ps.party_site_id