APPS.OZF_ACCRUAL_ENGINE dependencies on HZ_CUST_ACCOUNTS

Line 2232: hz_cust_accounts cust,

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
2236: AND acct_site.cust_account_id = cust.cust_account_id

Line 2428: hz_cust_accounts cust,

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
2432: AND acct_site.cust_account_id = cust.cust_account_id

Line 3830: FROM hz_cust_accounts

3826: l_planCurrAmtRemTbl planCurrAmtRemTbl;
3827: l_univCurrAmtTbl univCurrAmtTbl;
3828: CURSOR party_id_csr(p_cust_account_id NUMBER) IS
3829: SELECT party_id
3830: FROM hz_cust_accounts
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