DBA Data[Home] [Help]

APPS.OKE_K_APPROVAL_WF2 dependencies on FND_USER

Line 132: FROM fnd_user u

128:
129: CURSOR r ( C_role_name VARCHAR2 ) IS
130: SELECT nvl(p.full_name , u.user_name)
131: , u.email_address
132: FROM fnd_user u
133: , per_all_people_f p
134: WHERE u.user_name = C_role_name
135: AND p.person_id = u.employee_id
136: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date;