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
WHEREPTYPE.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
No comments:
Post a Comment
Thanks for making a comment.