APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 810: FROM hz_cust_site_uses_all

806: l_autopay_party_attr VARCHAR2(30);
807:
808: CURSOR c_org_id (p_site_use_id IN NUMBER) IS
809: SELECT org_id
810: FROM hz_cust_site_uses_all
811: WHERE site_use_id = p_site_use_id;
812:
813: -- 11/13/2001 mpande removed qualifier type
814: -- Added autopay_party_id for bugfix 6278466

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