DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 724: -- COMMENT : Validates Contact_id against hz_cust_account_roles

720:
721: --========================================================================
722: -- PROCEDURE : Validate_Contact
723: --
724: -- COMMENT : Validates Contact_id against hz_cust_account_roles
725: --========================================================================
726:
727: PROCEDURE Validate_Contact
728: (p_contact_id IN OUT NOCOPY NUMBER,

Line 733: FROM hz_cust_account_roles

729: x_return_status OUT NOCOPY VARCHAR2) IS
730:
731: CURSOR check_contact IS --TCA View removal Starts
732: SELECT Cust_account_role_id /*contact id*/
733: FROM hz_cust_account_roles
734: WHERE cust_account_role_id = p_contact_id AND
735: p_contact_id IS NOT NULL; --TCA View removal Ends
736:
737: