APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_ACCT_SITES_ALL

Line 2230: FROM hz_cust_acct_sites_all acct_site,

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

Line 2426: FROM hz_cust_acct_sites_all acct_site,

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

Line 3835: FROM hz_cust_acct_sites_all a,

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