DBA Data[Home] [Help]

APPS.WSH_UTIL_VALIDATE dependencies on HZ_CUST_ACCOUNT_ROLES

Line 702: -- COMMENT : Validates Contact_id against hz_cust_account_roles

698:
699: --========================================================================
700: -- PROCEDURE : Validate_Contact
701: --
702: -- COMMENT : Validates Contact_id against hz_cust_account_roles
703: --========================================================================
704:
705: PROCEDURE Validate_Contact
706: (p_contact_id IN OUT NOCOPY NUMBER,

Line 711: FROM hz_cust_account_roles

707: x_return_status OUT NOCOPY VARCHAR2) IS
708:
709: CURSOR check_contact IS --TCA View removal Starts
710: SELECT Cust_account_role_id /*contact id*/
711: FROM hz_cust_account_roles
712: WHERE cust_account_role_id = p_contact_id AND
713: p_contact_id IS NOT NULL; --TCA View removal Ends
714:
715: