To display employees created by Particular User

[khadeer]

Hi All
I want to know which employees are created in HRMS Module by the particular user say if i want to displayall the employees created by him on Logging through his account.

Thanks in Advance

[ahmadbilal]

try it
SELECT papf.person_id, papf.employee_number, papf.full_name,
(SELECT user_name
FROM fnd_user
WHERE user_id = papf.created_by) created_by, papf.last_update_login,
paaf.application_id, hla.location_code, papf.effective_start_date,
papf.effective_end_date
FROM per_all_people_f papf, per_all_assignments_f paaf,
hr_locations_all hla
WHERE papf.person_id = paaf.person_id
AND paaf.primary_flag = 'Y'
AND SYSDATE BETWEEN paaf.effective_start_date AND paaf.effective_end_date
AND paaf.location_id = hla.location_id