APPS.CS_SERVICEREQUEST_UTIL dependencies on HZ_CUST_ACCOUNTS

Line 5230: FROM hz_cust_accounts a

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

Line 5554: FROM hz_cust_accounts

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