SQL Query to get all the personalization on the OAF pages in the application

SELECT   PATH.path_docid perz_doc_id,

         jdr_mds_internal.getdocumentname (PATH.path_docid) perz_doc_path
    FROM jdr_paths PATH
   WHERE PATH.path_docid IN (
            SELECT DISTINCT comp_docid
                       FROM jdr_components
                      WHERE comp_seq = 0
                        AND comp_element = 'customization'
                        AND comp_id IS NULL)
     AND UPPER (jdr_mds_internal.getdocumentname (PATH.path_docid)) LIKE
                                                 UPPER ('%AbsenceHomePagePG%')
ORDER BY perz_doc_path;