APPS.HR_SECURITY_INTERNAL dependencies on PER_ASSIGNMENT_LIST

Line 5889: FROM per_assignment_list pal

5885: --
5886: CURSOR csr_get_static_asg_for_user IS
5887: SELECT pal.assignment_id
5888: ,pal.person_id
5889: FROM per_assignment_list pal
5890: WHERE pal.security_profile_id IS NOT NULL
5891: AND pal.user_id IS NOT NULL
5892: AND pal.security_profile_id = p_security_profile_id
5893: AND pal.user_id = p_user_id;

Line 5905: FROM per_assignment_list pal

5901: --
5902: CURSOR csr_get_static_asg IS
5903: SELECT pal.assignment_id
5904: ,pal.person_id
5905: FROM per_assignment_list pal
5906: WHERE pal.security_profile_id IS NOT NULL
5907: AND pal.user_id IS NULL
5908: AND pal.security_profile_id = p_security_profile_id;
5909:

Line 5925: -- lists for AND they have rows in per_assignment_list.

5921: -- If this is user-based, look for a user and
5922: -- security profile pair. Generally speaking, the static
5923: -- user lists will only be cached when it is known that
5924: -- this user is in the list of users to build static
5925: -- lists for AND they have rows in per_assignment_list.
5926: --
5927: IF g_dbg THEN op(l_proc, 20); END IF;
5928:
5929: IF p_cache_by_user THEN

Line 6483: FROM per_assignment_list pal

6479: IF g_dbg THEN op(l_proc, 30); END IF;
6480:
6481: SELECT pal.assignment_id
6482: INTO l_assignment_id
6483: FROM per_assignment_list pal
6484: WHERE pal.user_id IS NOT NULL
6485: AND pal.security_profile_id IS NOT NULL
6486: AND pal.user_id = p_user_id
6487: AND pal.security_profile_id = p_security_profile_id

Line 6707: -- Delete all assignments in per_assignment_list for this user

6703:
6704: IF p_user_id IS NOT NULL AND p_security_profile_id IS NOT NULL THEN
6705:
6706: --
6707: -- Delete all assignments in per_assignment_list for this user
6708: -- and this security profile.
6709: --
6710: IF g_dbg THEN op(l_proc, 20); END IF;
6711:

Line 6712: DELETE FROM per_assignment_list pal

6708: -- and this security profile.
6709: --
6710: IF g_dbg THEN op(l_proc, 20); END IF;
6711:
6712: DELETE FROM per_assignment_list pal
6713: WHERE pal.user_id IS NOT NULL
6714: AND pal.security_profile_id IS NOT NULL
6715: AND pal.user_id = p_user_id
6716: AND pal.security_profile_id = p_security_profile_id;

Line 7064: INSERT INTO per_assignment_list

7060: -- delete_asg_list_for_user) prior to insertion.
7061: --
7062: IF g_dbg THEN op(l_proc||'('||to_char(i)||'):'); END IF;
7063:
7064: INSERT INTO per_assignment_list
7065: (security_profile_id
7066: ,assignment_id
7067: ,person_id
7068: ,user_id

Line 8224: DELETE FROM per_assignment_list pal

8220: -- Assignment List.
8221: --
8222: IF g_dbg THEN op(l_proc, 50); END IF;
8223:
8224: DELETE FROM per_assignment_list pal
8225: WHERE pal.user_id IS NOT NULL
8226: AND pal.security_profile_id IS NOT NULL
8227: AND pal.user_id = p_user_id
8228: AND pal.security_profile_id = p_security_profile_id;