APPS.PA_RESOURCE_UTILS dependencies on FND_USER

Line 2423: FROM fnd_user

2419: l_root_manager_id NUMBER;
2420: BEGIN
2421: SELECT employee_id
2422: INTO l_root_manager_id
2423: FROM fnd_user
2424: WHERE user_id = p_user_id;
2425: RETURN l_root_manager_id;
2426: EXCEPTION
2427: WHEN NO_DATA_FOUND THEN

Line 4189: -- person using the fnd user name or user ID passed to the

4185: -- PROCEDURE
4186: -- get_resource_id
4187: -- PURPOSE
4188: -- This function returns the resource_id of the
4189: -- person using the fnd user name or user ID passed to the
4190: -- function
4191: FUNCTION get_resource_id(p_user_name IN VARCHAR2 DEFAULT NULL,
4192: p_user_id IN NUMBER DEFAULT NULL)
4193: RETURN NUMBER

Line 4207: FROM fnd_user

4203: -- 4586987 customer_id is changed to person_party_id
4204: /*
4205: SELECT employee_id, customer_id
4206: INTO l_emp_id, l_cust_id
4207: FROM fnd_user
4208: WHERE user_name = nvl(p_user_name, user_name)
4209: AND user_id = nvl(p_user_id, user_id);
4210: */
4211:

Line 4215: FROM fnd_user

4211:
4212: /* rewrite it for perf bug 4887375
4213: SELECT employee_id,person_party_id
4214: INTO l_emp_id,l_cust_id
4215: FROM fnd_user
4216: WHERE user_name = nvl(p_user_name,user_name)
4217: AND user_id =nvl(p_user_id,user_id);*/
4218:
4219: IF p_user_name IS NULL THEN

Line 4222: FROM fnd_user

4218:
4219: IF p_user_name IS NULL THEN
4220: SELECT employee_id, person_party_id
4221: INTO l_emp_id, l_cust_id
4222: FROM fnd_user
4223: WHERE user_id = p_user_id;
4224: ELSIF p_user_id IS NULL THEN
4225: SELECT employee_id, person_party_id
4226: INTO l_emp_id, l_cust_id

Line 4227: FROM fnd_user

4223: WHERE user_id = p_user_id;
4224: ELSIF p_user_id IS NULL THEN
4225: SELECT employee_id, person_party_id
4226: INTO l_emp_id, l_cust_id
4227: FROM fnd_user
4228: WHERE user_name = p_user_name;
4229: ELSE
4230: SELECT employee_id, person_party_id
4231: INTO l_emp_id, l_cust_id

Line 4232: FROM fnd_user

4228: WHERE user_name = p_user_name;
4229: ELSE
4230: SELECT employee_id, person_party_id
4231: INTO l_emp_id, l_cust_id
4232: FROM fnd_user
4233: WHERE user_name = p_user_name
4234: AND user_id = p_user_id;
4235: END IF;
4236: