APPS.PA_CUSTOMERS_CONTACTS_UTILS dependencies on HZ_CUST_ACCOUNT_ROLES
Line 519: FROM hz_cust_account_roles acct_role
515:
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'