APPS.PAY_PYUCSLIS_PKG dependencies on PER_SECURITY_USERS

Line 4994: FROM per_security_users seu

4990: SELECT seu.user_id
4991: ,usr.employee_id person_id
4992: ,seu.security_user_id
4993: ,seu.object_version_number
4994: FROM per_security_users seu
4995: ,fnd_user usr
4996: WHERE seu.security_profile_id = p_sec_prof_rec.security_profile_id
4997: AND (seu.process_in_next_run_flag = 'Y' OR l_all_static_users = 'Y')
4998: AND seu.user_id = usr.user_id

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

5196: l_sec_prof_rec hr_security_internal.g_sec_prof_r; -- per_security_profiles
5197: -- %ROWTYPE;
5198: -- Cursors:
5199: --
5200: -- check that user and profile exist in per_security_users
5201: --
5202: CURSOR csr_check_user_exists(p_user_id number, p_security_profile_id number)
5203: IS
5204: SELECT seu.user_id,

Line 5206: FROM per_security_users seu

5202: CURSOR csr_check_user_exists(p_user_id number, p_security_profile_id number)
5203: IS
5204: SELECT seu.user_id,
5205: seu.security_profile_id
5206: FROM per_security_users seu
5207: WHERE seu.user_id = p_user_id
5208: AND seu.security_profile_id = p_security_profile_id;
5209: --
5210: -- get security profile

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

5240: hr_utility.set_location(l_proc||'l_security_profile_id : '||
5241: l_security_profile_id,27);
5242: hr_utility.set_location('IF l_user_id or l_security profile id is null '
5243: ,30);
5244: hr_utility.set_location('then it has not been found in per_security_users'
5245: ,30);
5246: --
5247: -- if they exist then get security profile for user
5248: --

Line 5844: from per_security_users

5840:
5841: -- Start changes for bug 13504049
5842: cursor csr_get_static_users(lp_security_profile_id number) is
5843: select security_user_id
5844: from per_security_users
5845: where security_profile_id = lp_security_profile_id;
5846:
5847: l_static_user_id number;
5848: -- End changes for bug 13504049