1 Reply Latest reply: Nov 21, 2012 4:22 AM by Vigneswar Battu RSS

    Urgent Requirement

    917621
      Hi Everyone,

      Is there any report in HRMS which deals particularly on Employee Age Details
      Please provide me the necessary information if any report exists

      Thanks in Advance
        • 1. RE : Urgent requirement
          Vigneswar Battu
          Hi 914618,

          Please follow some ettiquette while posting questions -
          https://forums.oracle.com/forums/ann.jspa?annID=719

          Plese make sure your subject is relevant to your question.
          Please refrain from using Urgent , Help etc..

          All the seeded reports can be found here -
          http://docs.oracle.com/cd/E18727_01/doc.121/e13517/T5677T5680.htm
          SELECT PAPF.full_name,
          PAPF.date_of_birth,
          (MONTHS_BETWEEN(SYSDATE,PAPF.date_of_birth) / 12) AGE
          FROM per_all_people_f PAPF
          where papf.full_name like 'Battu%';
          Cheers,
          Vignesh