What is the IFS Cloud equivalent of Apps 8 Save Search with complex SQL logic?

Hi Everyone,

We are currently upgrading from IFS Apps 8 to IFS Cloud 25R2. In Apps 8 we have a Save Search feature that uses complex SQL logic with runtime substitution variables, correlated subqueries and API calls directly embedded in the search query.

Below is the code snippet of the save search in apps 8.

add_months(end_date,
    &AO.course_cfp.get_cf$_validity_length_m (
    &AO.course_cfp.get_objkey(course_id))) BETWEEN TRUNC(sysdate) AND nvl(to_date('&End_Date','dd/mm/yyyy') + 1 - 1/24/60/60,add_months(sysdate, 12))
    AND UPPER(course_id) like nvl(UPPER('&Course_ID'),'%')
    AND end_date =
    (
        SELECT MAX(end_date)
        FROM
            &AO.emp_training_history e
        WHERE
            &AO.emp_training_history_ov.company_id = e.company_id
            AND
            &AO.emp_training_history_ov.emp_no = e.emp_no
            AND
            &AO.emp_training_history_ov.course_id = e.course_id
    )
    AND
    &AO.course_api.get_valid_to(course_id) <= TRUNC(sysdate)
    AND NOT EXISTS
    (
        SELECT 1
        FROM
            &AO.employee_training_plan p
        WHERE
            &AO.emp_training_history_ov.company_id = p.company_id
            AND
            &AO.emp_training_history_ov.EMP_NO = P.EMP_NO
            AND
            &AO.emp_training_history_ov.course_id = p.course_id
            AND objstate                    in ('Planned','Scheduled')
    ) and &AO.company_person_api.get_employee_status(company_id, emp_no) = 'Active'

Is there an alternative way to achieve this in IFS Cloud?