428:
429:
430: select employee_id
431: into l_employee_id
432: from fnd_user
433: where user_id = l_wc_preparer_id;
434:
435: IF (g_asn_debug = 'Y') THEN
436: debug_log(FND_LOG.LEVEL_STATEMENT,
1249:
1250: elsif (l_next_approver(1).orig_system = 'FND') then --}{
1251: SELECT employee_id
1252: into l_next_approver_id
1253: FROM fnd_user
1254: WHERE user_id = l_next_approver(1).orig_system_id
1255: and trunc(sysdate) between start_date and nvl(end_date, sysdate+1);
1256: end if; --}
1257:
2866: END IF;
2867:
2868: SELECT HR.EMPLOYEE_ID
2869: INTO l_employee_id
2870: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2871: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2872: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2873: IF (g_asn_debug = 'Y') THEN
2874: debug_log(FND_LOG.LEVEL_STATEMENT,
2867:
2868: SELECT HR.EMPLOYEE_ID
2869: INTO l_employee_id
2870: FROM FND_USER FND, HR_EMPLOYEES_CURRENT_V HR
2871: WHERE FND.USER_ID = NVL(p_user_id, fnd_global.user_id)
2872: AND FND.EMPLOYEE_ID = HR.EMPLOYEE_ID;
2873: IF (g_asn_debug = 'Y') THEN
2874: debug_log(FND_LOG.LEVEL_STATEMENT,
2875: l_api_name,'l_employee_id '