APPS.AMW_WF_HIERARCHY_PKG dependencies on FND_USER

Line 2566: select nvl(employee_id, 0) into l_empid from fnd_user where user_id = p_user_id;

2562: l_empid number;
2563: l_dummy number;
2564: l_party_id number;
2565: begin
2566: select nvl(employee_id, 0) into l_empid from fnd_user where user_id = p_user_id;
2567:
2568: if l_empid = 0 then return 0; end if;
2569:
2570: begin

Line 2605: select nvl(employee_id, 0) into l_empid from fnd_user where user_id = p_user_id;

2601: -- check if the person is a manager of any audit unit. If no, return 0;
2602: -- If yes, check if he's the manager of the given org. If yes, return 1.
2603: -- if no, check if the current org is in the downward hierarchy of any of the orgs the person is a manager of; If yes, return 1, else return 0;
2604:
2605: select nvl(employee_id, 0) into l_empid from fnd_user where user_id = p_user_id;
2606:
2607: if l_empid = 0 then return 0; end if;
2608:
2609: begin