APPS.OZF_FUND_ADJUSTMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 679: FROM hz_cust_site_uses_all

675: l_autopay_party_attr VARCHAR2(30);
676:
677: CURSOR c_org_id (p_site_use_id IN NUMBER) IS
678: SELECT org_id
679: FROM hz_cust_site_uses_all
680: WHERE site_use_id = p_site_use_id;
681:
682: -- 11/13/2001 mpande removed qualifier type
683: -- Added autopay_party_id for bugfix 6278466

Line 712: FROM hz_cust_acct_sites_all sites, hz_cust_site_uses_all uses

708: -- 18-JAN-05 kdass get the cust_account_id from cust_acct_site_id
709: -- rimehrot for R12, added bill_to_site_use_id
710: CURSOR c_cust_account_id (p_site_use_id IN NUMBER) IS
711: SELECT sites.cust_account_id, uses.bill_to_site_use_id
712: FROM hz_cust_acct_sites_all sites, hz_cust_site_uses_all uses
713: WHERE uses.site_use_id = p_site_use_id
714: AND sites.cust_acct_site_id = uses.cust_acct_site_id;
715:
716: CURSOR c_get_cust_account_id(p_party_id IN NUMBER) IS