APPS.DPP_APPROVAL_PVT dependencies on FND_USER

Line 692: FROM fnd_user

688: ELSIF l_approversOut(i).user_id IS NOT NULL THEN -- If person id is null then retrieve the user id
689: BEGIN
690: SELECT email_address
691: INTO l_approver_email
692: FROM fnd_user
693: WHERE user_id = l_approversOut(i).user_id;
694: EXCEPTION
695: WHEN NO_DATA_FOUND THEN
696: FND_MESSAGE.set_name('DPP', 'DPP_NO_APP_DETAIL');

Line 1454: , fnd_user fu

1450:
1451: CURSOR csr_approvers (p_object_type varchar2, p_object_id number) IS
1452: SELECT fu.user_name
1453: FROM dpp_approval_access oaa
1454: , fnd_user fu
1455: WHERE oaa.object_type = p_object_type
1456: AND oaa.object_id = p_object_id
1457: AND oaa.approver_type = 'USER'
1458: AND oaa.approver_id = fu.user_id