select p.page_id, p.page_alias 
  from apex_application_page_branches b
     , apex_application_pages p
 where p.application_id = :p_app_id
   and b.application_id = p.application_id
   and b.page_id = :p_page_id
   and ( instr( ltrim(upper(b.branch_action), 'F?P='||'&'||'APP_ID.'||'&'||'FLOW_ID'), ':' || p.page_id || ':') =  1 
         or
         instr( ltrim(upper(b.branch_action), 'F?P='||'&'||'APP_ID.'||'&'||'FLOW_ID'), ':' || p.page_alias || ':') =  1 )