APPS.OZF_FUND_UTILIZED_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 130: FROM hz_cust_site_uses_all hzs,

126: AND status= 'A';
127:
128: CURSOR c_cust_id_billto (p_cust_id IN NUMBER) IS
129: SELECT hzas.cust_account_id, hzas.org_id
130: FROM hz_cust_site_uses_all hzs,
131: hz_cust_acct_sites_all hzas
132: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
133: AND hzs.site_use_id = p_cust_id;
134:

Line 137: FROM hz_cust_site_uses_all hzs,

133: AND hzs.site_use_id = p_cust_id;
134:
135: CURSOR c_cust_id_shipto (p_cust_id IN NUMBER) IS
136: SELECT hzas.cust_account_id, hzs.bill_to_site_use_id, hzas.org_id
137: FROM hz_cust_site_uses_all hzs,
138: hz_cust_acct_sites_all hzas
139: WHERE hzs.cust_acct_site_id = hzas.cust_acct_site_id
140: AND hzs.site_use_id = p_cust_id;
141:

Line 258: FROM hz_cust_site_uses_all

254:
255: -- get sites org id type
256: CURSOR c_benef_org_id (p_site_use_id IN NUMBER) IS
257: SELECT org_id
258: FROM hz_cust_site_uses_all
259: WHERE site_use_id = p_site_use_id;
260:
261: --nirprasa,ER 8399134
262: CURSOR c_get_offer_currency (p_activity_id IN NUMBER) IS