url sql query in oracle apex

--apex_util.prepare_url('f?p=' ||:APP_ID||':'||PAGE_ID||':'||:APP_SESSION|| '') as url

select 'Weekly Project' label, count(Project_no) value,apex_util.prepare_url( 'f?p='||:APP_ID ||':104:'||:APP_SESSION||':::' ) as url
from project_information
    where followup_person=:APP_USER
    and  TO_DATE(TO_DATE(PROJECT_INFORMATION.WK_DT,'DD-MON-RR HH24:MI:SS'),'DD-MON-RR') BETWEEN (to_date(sysdate)-6) AND to_date(sysdate)
union all
SELECT 'Monthly Project' label,count(Project_no) value,apex_util.prepare_url( 'f?p='||:APP_ID||':103:'||:APP

_SESSION||':::' ) as url
from project_information
where TO_DATE(TO_DATE(PROJECT_INFORMATION.WK_DT,'DD-MON-RR HH24:MI:SS'),'DD-MON-RR') BETWEEN add_months(to_date(sysdate),-1) AND to_date(sysdate)
and followup_person=:APP_USER
union all
select 'Total Project' label, count(Project_no) value,apex_util.prepare_url( 'f?p='||:APP_ID||':102:'||:APP_SESSION||':::' ) as url
    from project_information
where followup_person=:APP_USER