Line manager should not have access to their own record in my team
Summary:
Hi,
We have a requirement for configures role such as Line manager should not have access to their own record in redwood UI
for example:
My team > Add Absence > manager can see their own record and can add absence which he/she should not have access to apply to themself.
We configured Person security for public and person as below for managers
Custom criteria:
EXISTS (
SELECT 1
FROM per_all_assignments_m paam
WHERE paam.assignment_id = &TABLE_ALIAS.assignment_id
AND paam.assignment_type IN ('E', 'C', 'N', 'P')
AND paam.effective_latest_change = 'Y'
AND TRUNC(SYSDATE) BETWEEN TRUNC(paam.effective_start_date)
Tagged:
0