APPS.POR_UTIL_PKG dependencies on FND_USER

Line 407: fnd_user fnd,

403: IF l_cwk_profile = 'N' then
404: l_progress := '030';
405: SELECT 1 into l_count
406: FROM
407: fnd_user fnd,
408: per_employees_current_x hr
409: WHERE fnd.user_id = p_user_id
410: AND fnd.employee_id = hr.employee_id
411: AND rownum = 1;

Line 409: WHERE fnd.user_id = p_user_id

405: SELECT 1 into l_count
406: FROM
407: fnd_user fnd,
408: per_employees_current_x hr
409: WHERE fnd.user_id = p_user_id
410: AND fnd.employee_id = hr.employee_id
411: AND rownum = 1;
412: else
413: l_progress := '040';

Line 416: fnd_user fnd,

412: else
413: l_progress := '040';
414: SELECT 1 into l_count
415: FROM
416: fnd_user fnd,
417: per_workforce_current_x hr
418: WHERE fnd.user_id = p_user_id
419: AND fnd.employee_id = hr.person_id
420: AND rownum = 1;

Line 418: WHERE fnd.user_id = p_user_id

414: SELECT 1 into l_count
415: FROM
416: fnd_user fnd,
417: per_workforce_current_x hr
418: WHERE fnd.user_id = p_user_id
419: AND fnd.employee_id = hr.person_id
420: AND rownum = 1;
421:
422: end if;

Line 5984: FROM fnd_user WHERE employee_id = p_to_user_id;

5980: WHERE wfl.code = flv.language_code
5981: AND flv.installed_flag = 'B';
5982:
5983: SELECT email_address INTO l_email_address
5984: FROM fnd_user WHERE employee_id = p_to_user_id;
5985:
5986: l_po_email_performer := l_email_address
5987: || '.'
5988: || l_adhocuser_lang;