APPS.CS_SERVICEREQUEST_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 5228: FROM hz_cust_accounts a

5224: -- Initialize the return status.
5225: x_return_status := FND_API.G_RET_STS_SUCCESS;
5226:
5227: SELECT 'x' INTO l_test
5228: FROM hz_cust_accounts a
5229: WHERE a.cust_account_id = p_account_id
5230: AND a.party_id = p_customer_id
5231: AND a.status = 'A'
5232: -- Added to remove TCA violation -- Sysdate should fall within Account Activation Date and Termination Date -- anmukher -- 08/14/03

Line 5552: FROM hz_cust_accounts

5548: -- Initialize the return status.
5549: x_return_status := FND_API.G_RET_STS_SUCCESS;
5550: -- Validation
5551: SELECT 'x' INTO l_dummy
5552: FROM hz_cust_accounts
5553: WHERE cust_account_id = p_account_id
5554: AND party_id = p_party_id
5555: AND status = 'A';
5556: EXCEPTION