APPS.IBY_FNDCPT_EXTRACT_GEN_PVT dependencies on HZ_LOCATIONS

Line 658: FROM hz_party_sites ps, hz_locations loc,

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