APPS.HR_SIGNON dependencies on PER_SECURITY_PROFILES

Line 264: ,per_security_profiles p2

260: CURSOR c_get_sp_assignment
261: IS
262: SELECT p1.security_profile_id
263: FROM per_sec_profile_assignments p1
264: ,per_security_profiles p2
265: WHERE p1.security_profile_id = p2.security_profile_id
266: AND p1.user_id = p_user_id
267: AND p1.responsibility_id = p_responsibility_id
268: AND p1.responsibility_application_id = p_resp_app_id

Line 278: FROM per_security_profiles

274: --
275: CURSOR c_get_implicit_sp
276: IS
277: SELECT MIN(security_profile_id)
278: FROM per_security_profiles
279: WHERE business_group_id = p_business_group_id
280: AND view_all_flag = 'Y';
281: --
282: l_security_profile_id NUMBER DEFAULT NULL;

Line 669: l_null_row per_security_profiles%rowtype;

665: PROCEDURE Initialize_HR_Security
666: IS
667: --
668: l_security_profile_id NUMBER;
669: l_null_row per_security_profiles%rowtype;
670: --
671: BEGIN
672: hr_utility.set_location('Entering Initialize_HR_Security:',10);
673: -- fnd_log.string(1,'HR','Entering Initialize_HR_Security:'||'10');

Line 718: -- from per_security_profiles.

714: --fnd_log.string(1,'HR','l_security_profile_id: '||l_security_profile_id);
715: --
716: -- If a security profile was found/returned then populate the package
717: -- level global variable with the appropriate row for the ID
718: -- from per_security_profiles.
719: --
720: IF l_security_profile_id IS NOT NULL THEN
721: BEGIN
722: select *

Line 724: from per_security_profiles

720: IF l_security_profile_id IS NOT NULL THEN
721: BEGIN
722: select *
723: into hr_signon.g_hr_security_profile
724: from per_security_profiles
725: where security_profile_id = l_security_profile_id;
726: EXCEPTION
727: when NO_DATA_FOUND then
728: --