APPS.PAY_PYUCSLIS_PKG dependencies on PER_SECURITY_USERS

Line 2206: FROM per_security_users seu

2202: SELECT seu.user_id
2203: ,usr.employee_id person_id
2204: ,seu.security_user_id
2205: ,seu.object_version_number
2206: FROM per_security_users seu
2207: ,fnd_user usr
2208: WHERE seu.security_profile_id = p_sec_prof_rec.security_profile_id
2209: AND (seu.process_in_next_run_flag = 'Y' OR l_all_static_users = 'Y')
2210: AND seu.user_id = usr.user_id

Line 2371: -- check that user and profile exist in per_security_users

2367: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles
2368: -- %ROWTYPE;
2369: -- Cursors:
2370: --
2371: -- check that user and profile exist in per_security_users
2372: --
2373: CURSOR csr_check_user_exists(p_user_id number, p_security_profile_id number)
2374: IS
2375: SELECT seu.user_id,

Line 2377: FROM per_security_users seu

2373: CURSOR csr_check_user_exists(p_user_id number, p_security_profile_id number)
2374: IS
2375: SELECT seu.user_id,
2376: seu.security_profile_id
2377: FROM per_security_users seu
2378: WHERE seu.user_id = p_user_id
2379: AND seu.security_profile_id = p_security_profile_id;
2380: --
2381: -- get security profile

Line 2415: hr_utility.set_location('then it has not been found in per_security_users'

2411: hr_utility.set_location(l_proc||'l_security_profile_id : '||
2412: l_security_profile_id,27);
2413: hr_utility.set_location('IF l_user_id or l_security profile id is null '
2414: ,30);
2415: hr_utility.set_location('then it has not been found in per_security_users'
2416: ,30);
2417: --
2418: -- if they exist then get security profile for user
2419: --