APPS.OZF_FUND_UTILIZED_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 107: hz_cust_acct_sites_all hzas

103:
104: CURSOR c_cust_id_billto (p_cust_id IN NUMBER) IS
105: SELECT hzas.cust_account_id
106: FROM hz_cust_site_uses_all hzs,
107: hz_cust_acct_sites_all hzas
108: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
109: AND hzs.site_use_id = p_cust_id;
110:
111: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS

Line 114: hz_cust_acct_sites_all hzas

110:
111: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS
112: SELECT hzas.cust_account_id, hzs.bill_to_site_use_id
113: FROM hz_cust_site_uses_all hzs,
114: hz_cust_acct_sites_all hzas
115: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
116: AND hzs.site_use_id = p_cust_id;
117:
118: CURSOR c_valid_scantype_id (p_activity_id IN NUMBER, p_scan_type_id IN NUMBER) IS