APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on HZ_ROLE_RESPONSIBILITY
Line 520: ,hz_role_responsibility role_resp
516: -- Start of NEW SQL for Bug 4878913 SQL ID : 14907893
517: SELECT distinct acct_role.cust_account_role_id contact_id
518: INTO x_contact_id
519: FROM hz_cust_account_roles acct_role 520: ,hz_role_responsibility role_resp 521: WHERE
522: acct_role.cust_account_role_id = role_resp.cust_account_role_id
523: and acct_role.role_type = 'CONTACT'
524: and nvl(acct_role.current_role_state, 'A') = 'A'