1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

HRMS Intro help

Discussion in 'Oracle HRMS & Payroll' started by Bhavani, Nov 11, 2009.

  1. Bhavani

    Bhavani Active Member

    Messages:
    15
    Likes Received:
    0
    Trophy Points:
    80
    Please give me the step by step Oracle HRMS Navigation setup as I'm very new to ORacle Apps
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Have you seen the User Manual? Tutor docs? Searched Metalink? Searched this site?
     
  3. ram_rao

    ram_rao Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi I need
    the employee number, organization name under primary assignment,
    organization name under secondary assignment and associate effective
    date and end date. Again, I need a sql to generate these data
     
  4. Bharat

    Bharat Community Moderator Forum Guru

    Messages:
    1,747
    Likes Received:
    147
    Trophy Points:
    1,805
    Location:
    Vijayawada, India
    Hi Ramarao,

    Below is the query to retrieve the Organization for employees.

    Code (Text):

    SQL>
     SELECT PAPF.EMPLOYEE_NUMBER "Employee Number"
              , HAOU.NAME "Organization"

    FROM PER_ALL_PEOPLE_F PAPF
          , PER_ALL_ASSIGNMENTS_F PAAF,
          , HR_ALL_ORGANIZATION_UNITS HAOU

    WHERE PAPF.FULL_NAME = 'ABC, DEF'
       AND TRUNC(SYSDATE) BETWEEN TRUNC(PAPF.EFFECTIVE_START_DATE) AND TRUNC(PAPF.EFFECTIVE_END_DATE)
       AND PAAF.PERSON_ID (+) = PAPF.PERSON_ID
       AND HAOU.ORGANIZATION_ID (+) = PAAF.ORGANIZATION_ID;
     
    Based on the requirement change the restriction. For example I have suggested full name of the employee as parameter.