APPS.WSH_UTIL_VALIDATE dependencies on HZ_CUST_ACCOUNTS

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

642: --========================================================================
643: -- PROCEDURE : Validate_Customer
644: --
645: -- COMMENT : Validates Customer_id/Customer_number against
646: -- hz_cust_accounts. If both values are specified then only
647: -- Customer_Id is used
648: --========================================================================
649:
650: PROCEDURE Validate_Customer

Line 657: FROM hz_cust_accounts

653: x_return_status OUT NOCOPY VARCHAR2) IS
654:
655: CURSOR check_customer IS --Removal of TCA View Starts
656: SELECT cust_account_id /*customer_id */
657: FROM hz_cust_accounts
658: WHERE cust_account_id = p_customer_id AND
659: status = 'A' AND
660: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
661: UNION

Line 663: FROM hz_cust_accounts

659: status = 'A' AND
660: NVL(p_customer_id, FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
661: UNION
662: SELECT Cust_account_id/*customer_id */
663: FROM hz_cust_accounts
664: WHERE account_number /* customer number */ = p_customer_number AND
665: status = 'A' AND
666: NVL(p_customer_id, FND_API.G_MISS_NUM) = FND_API.G_MISS_NUM;
667: --Removal of TCA View Ends