Sql query is not workinkg

Content

Hi,

trying to excute the following sql via BI publisher per support document: Doc ID 2187087.1

Select * from per_assignment_supervisors_f sup,
           per_all_people_f pers,
           per_all_assignments_m assign1
where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865')
    and assign1.assignment_id = sup.assignment_id
    and pers.person_id = sup.person_id;


getting error ! see screenshot
glad if someone can assist!

thank you!!

Version

18B

Code Snippet

Select * from per_assignment_supervisors_f sup,
           per_all_people_f pers,
           per_all_assignments_m assign1
where manager_assignment_id in (select distinct assign.assignment_id from per_all_assignments_m assign where PERIOD_OF_SERVICE_ID = '100000000307865')
    and assign1.assignment_id = sup.assignment_id
    and pers.person_id = sup.person_id;