APPS.HR_SIGNON dependencies on PER_SECURITY_PROFILES

Line 237: ,per_security_profiles p2

233: CURSOR c_get_sp_assignment
234: IS
235: SELECT p1.security_profile_id
236: FROM per_sec_profile_assignments p1
237: ,per_security_profiles p2
238: WHERE p1.security_profile_id = p2.security_profile_id
239: AND p1.user_id = p_user_id
240: AND p1.responsibility_id = p_responsibility_id
241: AND p1.responsibility_application_id = p_resp_app_id

Line 251: FROM per_security_profiles

247: --
248: CURSOR c_get_implicit_sp
249: IS
250: SELECT MIN(security_profile_id)
251: FROM per_security_profiles
252: WHERE business_group_id = p_business_group_id
253: AND view_all_flag = 'Y';
254: --
255: l_security_profile_id NUMBER DEFAULT NULL;

Line 564: l_null_row per_security_profiles%rowtype;

560: PROCEDURE Initialize_HR_Security
561: IS
562: --
563: l_security_profile_id NUMBER;
564: l_null_row per_security_profiles%rowtype;
565: --
566: BEGIN
567:
568:

Line 600: -- from per_security_profiles.

596: );
597: --
598: -- If a security profile was found/returned then populate the package
599: -- level global variable with the appropriate row for the ID
600: -- from per_security_profiles.
601: --
602: IF l_security_profile_id IS NOT NULL THEN
603: BEGIN
604: select *

Line 606: from per_security_profiles

602: IF l_security_profile_id IS NOT NULL THEN
603: BEGIN
604: select *
605: into hr_signon.g_hr_security_profile
606: from per_security_profiles
607: where security_profile_id = l_security_profile_id;
608: EXCEPTION
609: when NO_DATA_FOUND then
610: --