APPS.OE_NOTIFY_USER_WF dependencies on FND_USER

Line 223: FROM fnd_user

219: BEGIN
220:
221: SELECT employee_id
222: INTO l_eid
223: FROM fnd_user
224: WHERE user_id = G_USER_TAB(idx).user_id;
225:
226: IF l_eid IS NULL THEN
227: SELECT name

Line 467: fnd_user fu

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'
471: AND hcar.current_role_state = 'A'

Line 479: fnd_user fu,

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
483: AND hcar.role_type = 'CONTACT'