371: IF l_cwk_profile = 'N' then
372: l_progress := '030';
373: SELECT 1 into l_count
374: FROM
375: fnd_user fnd,
376: per_employees_current_x hr
377: WHERE fnd.user_id = p_user_id
378: AND fnd.employee_id = hr.employee_id
379: AND rownum = 1;
373: SELECT 1 into l_count
374: FROM
375: fnd_user fnd,
376: per_employees_current_x hr
377: WHERE fnd.user_id = p_user_id
378: AND fnd.employee_id = hr.employee_id
379: AND rownum = 1;
380: else
381: l_progress := '040';
380: else
381: l_progress := '040';
382: SELECT 1 into l_count
383: FROM
384: fnd_user fnd,
385: per_workforce_current_x hr
386: WHERE fnd.user_id = p_user_id
387: AND fnd.employee_id = hr.person_id
388: AND rownum = 1;
382: SELECT 1 into l_count
383: FROM
384: fnd_user fnd,
385: per_workforce_current_x hr
386: WHERE fnd.user_id = p_user_id
387: AND fnd.employee_id = hr.person_id
388: AND rownum = 1;
389:
390: end if;