DBA Data[Home] [Help]

APPS.JTM_HOOK_UTIL_PKG dependencies on FND_USER

Line 78: , fnd_user usr

74: RETURN NUMBER IS
75: CURSOR c_resource ( b_client_name VARCHAR2) IS
76: SELECT resource_id
77: FROM jtf_rs_resource_extns rre
78: , fnd_user usr
79: WHERE usr.user_id = rre.user_id
80: AND usr.user_name = b_client_name;
81: r_resource c_resource%ROWTYPE;
82: BEGIN

Line 95: FROM fnd_user

91: RETURN NUMBER
92: IS
93: CURSOR c_user( b_client_name VARCHAR2 ) IS
94: SELECT user_id
95: FROM fnd_user
96: WHERE user_name = b_client_name;
97: r_user c_user%ROWTYPE;
98: BEGIN
99: OPEN c_user( p_client_name );