APPS.WSH_UTIL_VALIDATE dependencies on HZ_CUST_ACCOUNTS

Line 624: -- hz_cust_accounts. If both values are specified then only

620: --========================================================================
621: -- PROCEDURE : Validate_Customer
622: --
623: -- COMMENT : Validates Customer_id/Customer_number against
624: -- hz_cust_accounts. If both values are specified then only
625: -- Customer_Id is used
626: --========================================================================
627:
628: PROCEDURE Validate_Customer

Line 635: FROM hz_cust_accounts

631: x_return_status OUT NOCOPY VARCHAR2) IS
632:
633: CURSOR check_customer IS --Removal of TCA View Starts
634: SELECT cust_account_id /*customer_id */
635: FROM hz_cust_accounts
636: WHERE cust_account_id = p_customer_id AND
637: status = 'A' AND
638: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
639: UNION

Line 641: FROM hz_cust_accounts

637: status = 'A' AND
638: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
639: UNION
640: SELECT Cust_account_id/*customer_id */
641: FROM hz_cust_accounts
642: WHERE account_number /* customer number */ = p_customer_number AND
643: status = 'A' AND
644: NVL(p_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM;
645: --Removal of TCA View Ends