APPS.WSH_ECE_VIEWS_DEF dependencies on HZ_ORG_CONTACTS

Line 956: HZ_ORG_CONTACTS ORG_CONT,

952: substrb( REL_PARTY.PERSON_FIRST_NAME,1,40),
953: ORG_CONT.JOB_TITLE
954: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
955: HZ_RELATIONSHIPS REL,
956: HZ_ORG_CONTACTS ORG_CONT,
957: HZ_PARTIES REL_PARTY
958: WHERE ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id
959: AND REL.PARTY_ID = ACCT_ROLE.PARTY_ID
960: AND ACCT_ROLE.ROLE_TYPE = 'CONTACT'