APPS.FUN_CONTACTUS_EMAIL dependencies on PER_WORKFORCE_CURRENT_X

Line 225: FROM fnd_user fu, per_workforce_current_x pwx

221: IF (l_employee_id IS NOT NULL) THEN
222: -- FND user is an employee
223: SELECT pwx.full_name full_name, pwx.email_address email_address
224: INTO p_full_name, p_email_address
225: FROM fnd_user fu, per_workforce_current_x pwx
226: WHERE fu.employee_id IS NOT NULL
227: AND fu.employee_id = pwx.person_id
228: AND SYSDATE BETWEEN NVL(fu.start_date, SYSDATE) AND NVL(fu.end_date, SYSDATE)
229: AND fu.user_id = p_user_id;