APPS.OTA_RA_CON_API dependencies on HZ_CUST_ACCOUNT_ROLES

Line 112: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

108: PERSON_FIRST_NAME = substrb(p_first_name,1,40),
109: PERSON_PRE_NAME_ADJUNCT = p_title
110: where
111: PARTY_ID = (select PARTY.PARTY_ID
112: from HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
113: HZ_PARTIES PARTY,
114: HZ_RELATIONSHIPS REL,
115: HZ_ORG_CONTACTS ORG_CONT,
116: HZ_CUST_ACCOUNTS ROLE_ACCT

Line 129: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,

125: AND ACCT_ROLE.CUST_ACCOUNT_ROLE_ID = p_contact_id );
126: */
127: SELECT party.party_id, party.object_version_number
128: INTO x_party_id, x_party_object_version_number
129: FROM HZ_CUST_ACCOUNT_ROLES ACCT_ROLE,
130: HZ_PARTIES PARTY,
131: HZ_RELATIONSHIPS REL,
132: HZ_ORG_CONTACTS ORG_CONT,
133: HZ_CUST_ACCOUNTS ROLE_ACCT