APPS.OE_INLINE_CUSTOMER_PUB dependencies on HZ_CUST_ACCOUNT_ROLES
Line 367: From hz_cust_account_roles
363: -- if role found at site level then we create an acct level role
364: -- also
365: Cursor c_cust_acct_role IS
366: Select cust_account_role_id 367: From hz_cust_account_roles 368: Where party_id = p_contact_party_id
369: And cust_account_id = p_cust_acct_id
370: And role_type = 'CONTACT'
371: And status = 'A'