Payroll and OTL - EBS (MOSC)

MOSC Banner

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

edited Dec 8, 2016 11:57AM in Payroll and OTL - EBS (MOSC) Question

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center