SELECT null
,apr.region_name
,'#' || nvl(apr.static_id, 'R' || apr.region_id) r
FROM apex_application_page_regions apr
JOIN apex_appl_template_options ato
ON ato.region_template_id = apr.template_id
WHERE apr.application_id = :APP_ID
AND apr.page_id = :APP_PAGE_ID
AND ato.name = 'SCROLLSPY'
AND apr.region_template_options like '%:' || ato.css_classes || ':%'
ORDER BY apr.display_sequence