Wednesday, March 4, 2009

Retrieve the correct person type in HRMS

Use the below standard oracle function to retrieve the correct person type for an employee.

SELECT hr_person_type_usage_info.get_user_person_type (SYSDATE, &person_id)

If you want to retrieve the latest person type then perform the instr and substr on the output of the above query.

No comments: