APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_SITE_USES_ALL

Line 917: FROM hz_cust_site_uses_all

913:
914: --Added c_site_org_id for bug 6278466
915: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS
916: SELECT org_id
917: FROM hz_cust_site_uses_all
918: WHERE site_use_id = p_site_use_id;
919:
920: -- Cursor to get the sequence for utilization_id
921: CURSOR c_utilization_seq IS

Line 2231: hz_cust_site_uses_all site_use,

2227: */
2228: CURSOR c_cust_number (p_header_id IN NUMBER) IS
2229: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
2230: FROM hz_cust_acct_sites_all acct_site,
2231: hz_cust_site_uses_all site_use,
2232: hz_cust_accounts cust,
2233: oe_order_headers_all header
2234: WHERE header.header_id = p_header_id
2235: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 2427: hz_cust_site_uses_all site_use,

2423:
2424: CURSOR c_cust_number (p_header_id IN NUMBER) IS
2425: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
2426: FROM hz_cust_acct_sites_all acct_site,
2427: hz_cust_site_uses_all site_use,
2428: hz_cust_accounts cust,
2429: oe_order_headers_all header
2430: WHERE header.header_id = p_header_id
2431: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 2457: FROM hz_cust_site_uses_all

2453:
2454: --Added c_site_org_id for bug 6278466
2455: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS
2456: SELECT org_id
2457: FROM hz_cust_site_uses_all
2458: WHERE site_use_id = p_site_use_id;
2459:
2460: l_offer_type c_offer_type%ROWTYPE;
2461:

Line 3836: hz_cust_site_uses_all b

3832:
3833: CURSOR party_site_id_csr(p_account_site_id NUMBER) IS
3834: SELECT a.party_site_id
3835: FROM hz_cust_acct_sites_all a,
3836: hz_cust_site_uses_all b
3837: WHERE b.site_use_id = p_account_site_id
3838: AND b.cust_acct_site_id = a.cust_acct_site_id;
3839:
3840: CURSOR sales_transation_csr(p_line_id NUMBER) IS