Oracle Fusion Time and Labor

1. We can use below query to get HCM groups assigned to a person in HCM OTL.

select papf.papfson_number,

ppnf.last_name,

ppnf.first_name,

grp.group_name,

mem.effective_start_date,

mem.effective_end_date

from hwm_grp_members_f mem,

hwm_grps_vl grp,

per_all_people_f papf,

papf_papfson_names_f ppnf

where grp.grp_id = mem.grp_id

and papf.papfson_id = mem.member_id

and papf.papfson_id = ppnf.papfson_id

--and papf.papfson_number = '60004' -- Update with person number

and sysdate between mem.effective_start_date and mem.effective_end_date

and sysdate between ppnf.effective_start_date and ppnf.effective_end_date

--and grp.group_name like 'HCM GROUP NAME' -- Update with HCM Group Name