DBA Data[Home] [Help]

APPS.GHR_PDH_BUS dependencies on FND_USER

Line 253: -- Validates that the user_name exists in the table fnd_user and

249: -- |---------------------------< chk_user_name>----------------------------|
250: -- ----------------------------------------------------------------------------
251:
252: -- Description:
253: -- Validates that the user_name exists in the table fnd_user and
254: -- Pre-conditions:
255: --
256: --
257: -- In Arguments:

Line 296: from fnd_user

292: -- for 11.5.10 Performance repository changes
293:
294: /* cursor c_user_name is
295: select 1
296: from fnd_user
297: where upper(user_name) = upper(p_user_name); */
298: -- Bug 4863608 Perf changes.
299: CURSOR c_user_name is
300: SELECT 1

Line 301: FROM fnd_user

297: where upper(user_name) = upper(p_user_name); */
298: -- Bug 4863608 Perf changes.
299: CURSOR c_user_name is
300: SELECT 1
301: FROM fnd_user
302: WHERE user_name = upper(p_user_name);
303: /* CURSOR c_user_name IS
304: SELECT 1
305: FROM fnd_user

Line 305: FROM fnd_user

301: FROM fnd_user
302: WHERE user_name = upper(p_user_name);
303: /* CURSOR c_user_name IS
304: SELECT 1
305: FROM fnd_user
306: WHERE UPPER(user_name) = UPPER(p_user_name)
307: AND user_name LIKE UPPER(p_user_name); */
308:
309: begin