APPS.HR_SIGNON dependencies on PER_SEC_PROFILE_ASSIGNMENTS

Line 220: -- PER_SEC_PROFILE_ASSIGNMENTS table.

216: -- level.
217: --
218: -- For R11i all security profile assignments are maintained through
219: -- the 'assign security profiles' form, and are stored in the
220: -- PER_SEC_PROFILE_ASSIGNMENTS table.
221: --
222: --
223: FUNCTION Get_SP_ID
224: (p_user_id IN NUMBER

Line 236: FROM per_sec_profile_assignments p1

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

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

423: -- Retrieve the value for the ENABLE_SECURITY_GROUPS profile option.
424: -- If this is enabled then the business group for the session is
425: -- derived from the security group that the user selected at login.
426: -- If security groups are enabled then the security profile assignment
427: -- for the session is found by querying PER_SEC_PROFILE_ASSIGNMENTS
428: -- and if no explicit assignment exists then default view-all profile
429: -- for the business group is assigned.
430: --
431: -- If security groups are not enabled then the business group and

Line 468: -- PER_SEC_PROFILE_ASSIGNMENTS table.

464: -- session by inspecting the relavent profile option at resp/site
465: -- level.
466: -- For R11i all security profile assignments are maintained through
467: -- the 'assign security profiles' form, and are stored in the
468: -- PER_SEC_PROFILE_ASSIGNMENTS table.
469: --
470: l_security_profile_id
471: := Get_SP_ID
472: (p_user_id => p_user_id