APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_SITE_USES_ALL

Line 765: FROM hz_cust_site_uses_all

761:
762: --Added c_site_org_id for bug 6278466
763: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS
764: SELECT org_id
765: FROM hz_cust_site_uses_all
766: WHERE site_use_id = p_site_use_id;
767:
768: -- Cursor to get the sequence for utilization_id
769: CURSOR c_utilization_seq IS

Line 1822: hz_cust_site_uses_all site_use,

1818: */
1819: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1820: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1821: FROM hz_cust_acct_sites_all acct_site,
1822: hz_cust_site_uses_all site_use,
1823: hz_cust_accounts cust,
1824: oe_order_headers_all header
1825: WHERE header.header_id = p_header_id
1826: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 1998: hz_cust_site_uses_all site_use,

1994:
1995: CURSOR c_cust_number (p_header_id IN NUMBER) IS
1996: SELECT cust.cust_account_id, header.invoice_to_org_id, header.ship_to_org_id
1997: FROM hz_cust_acct_sites_all acct_site,
1998: hz_cust_site_uses_all site_use,
1999: hz_cust_accounts cust,
2000: oe_order_headers_all header
2001: WHERE header.header_id = p_header_id
2002: AND acct_site.cust_acct_site_id = site_use.cust_acct_site_id

Line 2028: FROM hz_cust_site_uses_all

2024:
2025: --Added c_site_org_id for bug 6278466
2026: CURSOR c_site_org_id (p_site_use_id IN NUMBER) IS
2027: SELECT org_id
2028: FROM hz_cust_site_uses_all
2029: WHERE site_use_id = p_site_use_id;
2030:
2031: l_offer_type c_offer_type%ROWTYPE;
2032:

Line 2971: hz_cust_site_uses_all b

2967:
2968: CURSOR party_site_id_csr(p_account_site_id NUMBER) IS
2969: SELECT a.party_site_id
2970: FROM hz_cust_acct_sites_all a,
2971: hz_cust_site_uses_all b
2972: WHERE b.site_use_id = p_account_site_id
2973: AND b.cust_acct_site_id = a.cust_acct_site_id;
2974:
2975: CURSOR sales_transation_csr(p_line_id NUMBER) IS