DBA Data[Home] [Help]

APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on HZ_CUST_ACCT_SITES_ALL

Line 843: FROM hz_cust_acct_sites_all sites, hz_cust_site_uses_all uses

839: -- 18-JAN-05 kdass get the cust_account_id from cust_acct_site_id
840: -- rimehrot for R12, added bill_to_site_use_id
841: CURSOR c_cust_account_id (p_site_use_id IN NUMBER) IS
842: SELECT sites.cust_account_id, uses.bill_to_site_use_id
843: FROM hz_cust_acct_sites_all sites, hz_cust_site_uses_all uses
844: WHERE uses.site_use_id = p_site_use_id
845: AND sites.cust_acct_site_id = uses.cust_acct_site_id;
846:
847: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS