DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on HZ_RELATIONSHIPS

Line 480: hz_relationships hr

476: UNION
477: SELECT fu.user_id, fu.user_name
478: FROM hz_cust_account_roles hcar,
479: fnd_user fu,
480: hz_relationships hr
481: WHERE hcar.cust_account_id = l_customer_id
482: AND hcar.party_id = hr.party_id
483: AND hcar.role_type = 'CONTACT'
484: AND hcar.current_role_state = 'A'