[Home] [Help]
287: -- this from picking up static user lists.
288: --
289: cursor get_people(p_security_profile_id number) is
290: select person_id
291: from per_person_list
292: where security_profile_id=p_security_profile_id
293: and granted_user_id is null;
294:
295: --
320: where trunc(sysdate) between a.effective_start_date
321: and a.effective_end_date
322: and assignment_type <> 'B') asg
323: where exists (select null
324: from per_person_list ppl
325: where ppl.security_profile_id=p_security_profile_id
326: and ppl.person_id=asg.person_id)
327: connect by asg.supervisor_id = prior asg.person_id
328: and Level<=nvl(p_max_levels,Level)+1
353: and a.effective_end_date
354: and assignment_type <> 'B'
355: and a.primary_flag='Y' ) asg
356: where exists (select null
357: from per_person_list ppl
358: where ppl.security_profile_id=p_security_profile_id
359: and ppl.person_id=asg.person_id)
360: connect by asg.supervisor_id = prior asg.person_id
361: and Level<=nvl(p_max_levels,Level)+1
509: and g_context.view_all_payrolls_flag='Y'
510: and g_context.custom_restriction_flag='N' then
511: --
512: -- we are only restricting by supervisor so do not
513: -- join to per_person_list
514: --
515: if g_context.exclude_secondary_asgs_flag='Y' then
516: --
517: -- find all of the people who are in the supervisor hierarchy of
541: -- org, pos and custom security is not in use and (bug 3507431)
542: -- the security is not on an individual assignment level.
543: --
544: -- we are also restricting by another thing, so join to
545: -- per_person_list
546: --
547: if g_context.exclude_secondary_asgs_flag='Y' then
548: --
549: -- find all of the people who are in the supervisor hierarchy of
570: end if;
571: end if;
572:
573: --
574: -- The static per_person_list is now cached during evaluate_access
575: -- so this code can be commented out. Although this is cached
576: -- into a separate table and synched up at the moment, it is
577: -- expected that g_person_list can be obsoleted and replaced by
578: -- g_per_tbl.
581: --
582: -- Bug 2807573 DK 17-FEB-2003
583: --
584: -- For a view all security profile we don't need to get
585: -- the per_person_list. It should be empty for such a profile
586: -- but checking involves a range scan and hence unnecessary i/o.
587: --
588: IF ( g_context.view_all_flag = 'N' ) THEN
589:
602: -- orgs, positions, people, etc.
603: --
604: -- Where user-based security or assignment-level security is used,
605: -- the security is dynamically assessed, otherwise it picks up
606: -- the permissions from per_person_list.
607: --
608: -- hr_security_internal.evaluate_access keeps a separate person
609: -- cache at the moment, although it is expected that g_person_list
610: -- can be completely replaced by g_per_tbl in the near future
640: --
641: -- add granted users if using a restricted profile.
642: -- A user can have been granted access to a person but still be using
643: -- a view all responsiblity. In which case there will be rows in
644: -- PER_PERSON_LIST but as this is a view all profile we can ignore them.
645: --
646: -- 2807573 21-FEB-2003
647: -- Only deal with grant access when using a restricted profile.
648: --
1149:
1150: -- A condition with view_all_contacts_flag = All and
1151: -- view_all_candidates_flag = None, will not be taken care in below
1152: -- IF condition. ie: in such a scenario, its been decided that contacts
1153: -- will be populated in per_person_list through PERSLM. Thereby this
1154: -- function (SHOW_PERSON) will return a TRUE through CHECK_PERSON_LIST.
1155:
1156: -- Contacts Candidates Contacts cached
1157: -- ------------------------------------------
1311:
1312: -- A condition with view_all_contacts_flag = All and
1313: -- view_all_candidates_flag = None, will not be taken care in below
1314: -- IF condition. ie: in such a scenario, its been decided that contacts
1315: -- will be populated in per_person_list through PERSLM. Thereby this
1316: -- function (SHOW_PERSON) will return a TRUE through CHECK_PERSON_LIST.
1317:
1318: -- Contacts Candidates Contacts cached
1319: -- ------------------------------------------