DBA Data[Home] [Help]

APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on HZ_PARTY_SITES

Line 770: FROM hz_party_sites ps, hz_locations loc,

766: AND user_pf.sys_dc_profile_code = sys_pf.sys_dc_profile_code;
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