APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 1821: FROM hz_cust_acct_sites_all acct_site,

1817: WHERE header_id = p_header_id;
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

Line 1997: FROM hz_cust_acct_sites_all acct_site,

1993: WHERE adj.price_Adjustment_id = p_price_adjustment_id;
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

Line 2970: FROM hz_cust_acct_sites_all a,

2966: WHERE cust_account_id = p_cust_account_id;
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: