Help with Person Security Profile

Summary

Sql on custom criteria on person security profile

Content

Please see below SQL I have created for Security Profile - it's throwing out a "ORA-28113: policy predicate has error" message Can anyone help? &TABLE_ALIAS.person_id IN (SELECT PAA.PERSON_ID FROM PER_ALL_ASSIGNMENTS_M PAA, PER_JOBS PJ, PER_PERSON_TYPES_TL PPT, PER_PERIODS_OF_SERVICE PPS WHERE ppt.person_type_id = paa.person_type_id AND pj.job_id = paa.job_id AND ( ppt.user_person_type IN ('Retail Management Employee','Retail Employee') OR pj.name IN ('Deputy Store Manager','Store Manager','Store Manager Designate','Senior Store Manager', 'General Manager') ) AND paa.assignment_type in ('E','C') AND paa.period_of_service_id = pps.period_of_service_id AND pl.per_locations = paa.Location_id AND ((pps.date_start = (select max(pps1.date_start) from per_periods_of_service pps1 where pps1.person_id = paa.person_id) and trunc(sysdate) between paa.effective_start_date and paa.effective_end_date) OR pps.date_start > sysdate) AND PAA.LEGISLATION_CODE = 'IE' OR PL.INTERNAL_LOCATION_CODE in ('NEWRY', 'BALLYMENA', 'RUSHMERE', 'FOYLESIDE', 'BELFAST - OSW', 'BELFAST'))