Employee Filter LOV not working in performance goals
We are creating a custom role using person security profiles. Employee/Manager filter LOV is not getting populated for it but if i search using department filter data is populating.
Custom Criteria -
EXISTS(
SELECT 1
FROM PER_POSITION_HIERARCHY_F hier
,PER_POSITION_HIERARCHY_F hier1
, PER_ALL_ASSIGNMENTS_M asg
, PER_ALL_ASSIGNMENTS_M asg1
WHERE
TRUNC(SYSDATE) BETWEEN hier.effective_start_date AND hier.effective_end_date
AND hier.position_id = asg.position_id
AND TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date
AND asg.assignment_status_type = 'ACTIVE'
AND asg1.assignment_type = 'E'
0