DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 660: hz_cust_acct_sites_all hz_cs

656: CURSOR l_lang_territory_csr (p_trxnmid IN NUMBER) IS
657: SELECT loc.language, loc.country
658: FROM hz_party_sites ps, hz_locations loc,
659: iby_trxn_summaries_all txn, hz_cust_site_uses_all hz_csu,
660: hz_cust_acct_sites_all hz_cs
661: where txn.trxnmid = p_trxnmid
662: and hz_csu.cust_acct_site_id = hz_cs.cust_acct_site_id
663: and hz_cs.party_site_id = ps.party_site_id
664: AND txn.acct_site_use_id = hz_csu.site_use_id(+)