DBA Data[Home] [Help]

APPS.OZF_NET_ACCRUAL_ENGINE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 16: FROM hz_cust_accounts

12:
13: -- Segment and buying group has no acct info. use party_id for validation
14: CURSOR c_party_id IS
15: SELECT party_id
16: FROM hz_cust_accounts
17: WHERE cust_account_id = p_sold_to_org_id;
18:
19: CURSOR c_customer_qualified(p_party_id NUMBER) IS
20: SELECT 'Y'

Line 79: FROM hz_cust_accounts

75: RETURN VARCHAR2
76: IS
77: CURSOR c_party_id IS -- segment and buying group has no acct info. use party_id for validation
78: SELECT party_id
79: FROM hz_cust_accounts
80: WHERE cust_account_id = p_sold_to_org_id;
81:
82: CURSOR c_customer_qualified(p_party_id NUMBER) IS
83: SELECT 'Y'

Line 2043: hz_cust_accounts cust

2039: CURSOR c_cust_number (p_invoice_to_org_id IN NUMBER) IS
2040: SELECT cust.cust_account_id
2041: FROM hz_cust_acct_sites_all acct_site,
2042: hz_cust_site_uses_all site_use,
2043: hz_cust_accounts cust
2044: WHERE acct_site.cust_acct_site_id = site_use.cust_acct_site_id
2045: AND acct_site.cust_account_id = cust.cust_account_id
2046: AND site_use.site_use_id = p_invoice_to_org_id ;
2047: