DBA Data[Home] [Help]

APPS.POR_UTIL_PKG dependencies on FND_USER

Line 375: fnd_user fnd,

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;

Line 377: WHERE fnd.user_id = p_user_id

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';

Line 384: fnd_user fnd,

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;

Line 386: WHERE fnd.user_id = p_user_id

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;