Here you go

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