APPS.PA_RESOURCE_UTILS dependencies on FND_USER

Line 2306: FROM fnd_user

2302: l_root_manager_id NUMBER;
2303: BEGIN
2304: SELECT employee_id
2305: INTO l_root_manager_id
2306: FROM fnd_user
2307: WHERE user_id = p_user_id;
2308: RETURN l_root_manager_id;
2309: EXCEPTION
2310: WHEN NO_DATA_FOUND THEN

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

3849: -- PROCEDURE
3850: -- get_resource_id
3851: -- PURPOSE
3852: -- This function returns the resource_id of the
3853: -- person using the fnd user name or user ID passed to the
3854: -- function
3855: FUNCTION get_resource_id(p_user_name IN VARCHAR2 DEFAULT NULL,
3856: p_user_id IN NUMBER DEFAULT NULL)
3857: RETURN NUMBER

Line 3871: FROM fnd_user

3867: -- 4586987 customer_id is changed to person_party_id
3868: /*
3869: SELECT employee_id, customer_id
3870: INTO l_emp_id, l_cust_id
3871: FROM fnd_user
3872: WHERE user_name = nvl(p_user_name, user_name)
3873: AND user_id = nvl(p_user_id, user_id);
3874: */
3875:

Line 3879: FROM fnd_user

3875:
3876: /* rewrite it for perf bug 4887375
3877: SELECT employee_id,person_party_id
3878: INTO l_emp_id,l_cust_id
3879: FROM fnd_user
3880: WHERE user_name = nvl(p_user_name,user_name)
3881: AND user_id =nvl(p_user_id,user_id);*/
3882:
3883: IF p_user_name IS NULL THEN

Line 3886: FROM fnd_user

3882:
3883: IF p_user_name IS NULL THEN
3884: SELECT employee_id, person_party_id
3885: INTO l_emp_id, l_cust_id
3886: FROM fnd_user
3887: WHERE user_id = p_user_id;
3888: ELSIF p_user_id IS NULL THEN
3889: SELECT employee_id, person_party_id
3890: INTO l_emp_id, l_cust_id

Line 3891: FROM fnd_user

3887: WHERE user_id = p_user_id;
3888: ELSIF p_user_id IS NULL THEN
3889: SELECT employee_id, person_party_id
3890: INTO l_emp_id, l_cust_id
3891: FROM fnd_user
3892: WHERE user_name = p_user_name;
3893: ELSE
3894: SELECT employee_id, person_party_id
3895: INTO l_emp_id, l_cust_id

Line 3896: FROM fnd_user

3892: WHERE user_name = p_user_name;
3893: ELSE
3894: SELECT employee_id, person_party_id
3895: INTO l_emp_id, l_cust_id
3896: FROM fnd_user
3897: WHERE user_name = p_user_name
3898: AND user_id = p_user_id;
3899: END IF;
3900: