Here you go

Showing posts with label Oracle Person Type. Show all posts
Showing posts with label Oracle Person Type. Show all posts

Thursday, June 12, 2014

How to find EBS Employee Type?



Query to find Person Type:



        SELECT
                PAPF.EMPLOYEE_NUMBER,
                PAPF.FULL_NAME,
                PPT.USER_PERSON_TYPE        PERSON_TYPE  
        FROM

                PER_PERSON_TYPE_USAGES_F    PTYPE,

                PER_PERSON_TYPES            PPT,

                PER_ALL_PEOPLE_F            PAPF

        WHERE
                PTYPE.PERSON_ID         = PAPF.PERSON_ID
        AND     PPT.PERSON_TYPE_ID      = PTYPE.PERSON_TYPE_ID
        AND     SYSDATE BETWEEN PTYPE.EFFECTIVE_START_DATE  AND PTYPE.EFFECTIVE_END_DATE
        AND     SYSDATE BETWEEN PAPF.EFFECTIVE_START_DATE   AND PAPF.EFFECTIVE_END_DATE