APPS.HR_SIGNON dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 247: -- PER_SEC_PROFILE_ASSIGNMENTS table.

243: -- level.
244: --
245: -- For R11i all security profile assignments are maintained through
246: -- the 'assign security profiles' form, and are stored in the
247: -- PER_SEC_PROFILE_ASSIGNMENTS table.
248: --
249: --
250: FUNCTION Get_SP_ID
251: (p_user_id IN NUMBER

Line 263: FROM per_sec_profile_assignments p1

259: --
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

Line 496: -- for the session is found by querying PER_SEC_PROFILE_ASSIGNMENTS

492: -- Retrieve the value for the ENABLE_SECURITY_GROUPS profile option.
493: -- If this is enabled then the business group for the session is
494: -- derived from the security group that the user selected at login.
495: -- If security groups are enabled then the security profile assignment
496: -- for the session is found by querying PER_SEC_PROFILE_ASSIGNMENTS
497: -- and if no explicit assignment exists then default view-all profile
498: -- for the business group is assigned.
499: --
500: -- If security groups are not enabled then the business group and

Line 549: -- PER_SEC_PROFILE_ASSIGNMENTS table.

545: -- session by inspecting the relavent profile option at resp/site
546: -- level.
547: -- For R11i all security profile assignments are maintained through
548: -- the 'assign security profiles' form, and are stored in the
549: -- PER_SEC_PROFILE_ASSIGNMENTS table.
550: --
551: l_security_profile_id
552: := Get_SP_ID
553: (p_user_id => p_user_id