APPS.HR_SECURITY_INTERNAL dependencies on PER_PERSON_LIST_CHANGES

Line 6009: FROM per_person_list_changes plc

6005: -- evaluated) but did once have an assignment.
6006: --
6007: CURSOR csr_get_static_per IS
6008: SELECT plc.person_id
6009: FROM per_person_list_changes plc
6010: WHERE plc.security_profile_id IS NOT NULL
6011: AND plc.security_profile_id = p_security_profile_id
6012: AND NOT EXISTS
6013: (SELECT NULL

Line 7675: -- rows in per_person_list_changes are not processed and so not visible

7671: ,p_use_static_lists => p_use_static_lists);
7672:
7673: --
7674: -- Contacts for the people visible (both related and unrelated) and
7675: -- rows in per_person_list_changes are not processed and so not visible
7676: -- for all types of user-based security.
7677:
7678: -- The reason for this is to remain consistent with supervisor security
7679: -- (been around since 11i) where PPLC people were not processed and

Line 7715: -- Add the people in per_person_list_changes to the cache.

7711: add_contacts_to_cache(p_effective_date
7712: ,p_sec_prof_rec.business_group_id);
7713: --
7714: end if;
7715: -- Add the people in per_person_list_changes to the cache.
7716: -- It is expected that this can be obsoleted at a future
7717: -- date, because per_person_list_changes is effectively
7718: -- obsolete and is retained solely for the purpose of not
7719: -- breaking customer custom processes that use this table.

Line 7717: -- date, because per_person_list_changes is effectively

7713: --
7714: end if;
7715: -- Add the people in per_person_list_changes to the cache.
7716: -- It is expected that this can be obsoleted at a future
7717: -- date, because per_person_list_changes is effectively
7718: -- obsolete and is retained solely for the purpose of not
7719: -- breaking customer custom processes that use this table.
7720:
7721: -- add_per_list_changes_to_cache(p_sec_prof_rec.security_profile_id