Announcements for Payroll and OTL can now be found in the Announcements - Payroll and OTL - EBS (MOSC) subcategory. Follow to be sure you don't miss a thing!
OTL: Current timekeeper group for an employee
Dear Friends,
I am writing a query to get the current timekeeper group for a particular employee. Unfortunately, this query is giving me past timekeeper groups also. I can't see anything as a filter to get the current one. Find query below
SELECT htg.tk_group_name, htgqc.criteria_id
FROM per_all_people_f papf,
hxc_tk_group_queries htgq,
hxc_tk_group_query_criteria htgqc,
hxc_tk_groups htg
WHERE papf.person_id = htgqc.criteria_id
AND papf.person_id = :p_resource_id
AND htgqc.tk_group_query_id = htgq.tk_group_query_id
AND htgq.tk_group_id = htg.tk_group_id