[Home] [Help]
APPS.OZF_CLAIM_SETTLEMENT_PVT dependencies on HZ_CUST_ACCOUNTS
Line 239: FROM ozf_cust_trd_prfls cust, hz_cust_accounts hz
235:
236: --//Bugfix : 8774738
237: CURSOR trd_prfl_count_csr(p_id IN NUMBER) is
238: SELECT NVL(COUNT(trade_profile_id), 0)
239: FROM ozf_cust_trd_prfls cust, hz_cust_accounts hz
240: WHERE cust.party_id = hz.party_id
241: AND hz.cust_account_id = p_id;
242:
243: l_count NUMBER := 0;