1247:
1248: WHEN S_CLM_INFO_FLAG = 'N' AND
1249: work_approver_user_name IS NOT NULL
1250: AND NOT EXISTS (SELECT 1
1251: FROM PER_WORKFORCE_CURRENT_X peo,
1252: FND_USER fu
1253: WHERE fu.user_name = work_approver_user_name
1254: AND fu.employee_id = peo.person_id
1255: AND SYSDATE >= nvl(fu.start_date, SYSDATE)