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;