APPS.IEX_SCORE_NEW_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 605: from hz_cust_site_uses_all hcsua,hz_cust_acct_sites_all hcasa, hz_cust_accounts hca

601: l_object_id:=t_object_ids(l_count);
602: elsif l_jtf_obj_code='IEX_BILLTO' then
603: select hcsua.location,hca.account_number
604: into l_object_name,l_acct_number
605: from hz_cust_site_uses_all hcsua,hz_cust_acct_sites_all hcasa, hz_cust_accounts hca
606: where hcsua.cust_acct_site_id=hcasa.cust_acct_site_id
607: and hcasa.cust_account_id=hca.cust_account_id
608: and hcsua.site_use_code='BILL_TO'
609: and hcsua.site_use_id=t_object_ids(l_count);