APPS.WSH_ROUTING_RESPONSE_PKG dependencies on FND_USER

Line 929: FROM fnd_user

925: FUNCTION GetFromRole(p_UserId IN NUMBER) RETURN VARCHAR2 IS
926: --
927: CURSOR c_GetUser is
928: SELECT user_name
929: FROM fnd_user
930: WHERE user_id = p_UserId;
931: --
932: v_Name fnd_user.user_name%TYPE;
933: --

Line 932: v_Name fnd_user.user_name%TYPE;

928: SELECT user_name
929: FROM fnd_user
930: WHERE user_id = p_UserId;
931: --
932: v_Name fnd_user.user_name%TYPE;
933: --
934: l_debugOn BOOLEAN;
935: l_moduleName CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.GetFromRole';
936: --

Line 1048: FROM fnd_user fu, hz_relationships hz

1044: WHERE name = 'HZ_PARTY:' || p_relId;
1045: --
1046: CURSOR c_GetPOUser(p_vendorID NUMBER) IS
1047: SELECT fu.user_name, fu.email_address
1048: FROM fnd_user fu, hz_relationships hz
1049: WHERE hz.subject_id = p_vendorId
1050: AND hz.object_id = fu.person_party_id --IB-phase-2 Vendor Merge
1051: AND hz.subject_type = 'ORGANIZATION'
1052: AND hz.object_type = 'PERSON'