APPS.OE_NOTIFY_USER_WF dependencies on HZ_CUST_ACCOUNT_ROLES

Line 466: FROM hz_cust_account_roles hcar,

462: SELECT DISTINCT user_id, user_name -- 12616799
463: BULK COLLECT INTO G_USER_TAB
464: FROM (
465: SELECT fu.user_id, fu.user_name
466: FROM hz_cust_account_roles hcar,
467: fnd_user fu
468: WHERE hcar.cust_account_id = l_customer_id
469: AND hcar.party_id = fu.customer_id
470: AND hcar.role_type = 'CONTACT'

Line 478: FROM hz_cust_account_roles hcar,

474: AND (fu.end_date IS NULL OR fu.end_date > SYSDATE)
475: AND fnd_profile.value_specific('ONT_SEND_STATUS_UPDATE_NOTIFICATION',fu.user_id) = 'Y'
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