1197: )
1198:
1199: WHEN work_approver_user_name IS NOT NULL
1200: AND NOT EXISTS (SELECT 1
1201: FROM PER_WORKFORCE_CURRENT_X peo,
1202: FND_USER fu
1203: WHERE fu.user_name = work_approver_user_name
1204: AND fu.employee_id = peo.person_id
1205: AND SYSDATE >= nvl(fu.start_date, SYSDATE)