What's new in Customer Journeys?

Connect and learn more!
can't find element group (object group) in payroll — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

can't find element group (object group) in payroll

Received Response
24
Views
1
Comments

Hello, I'm trying this query to get the employees who are included in an element group (object group) but it didn't results in anything SELECT distinct person_number,person_id FROM per_all_people_f WHERE person_id IN ( SELECT person_id FROM pay_pay_relationships_dn WHERE payroll_relationship_id IN (SELECT OBJECT_ID FROM pay_object_group_amends WHERE object_group_id in (Select object_group_id from PAY_OBJECT_GROUPS where BASE_OBJECT_GROUP_NAME='....................') and INCLUDE_OR_EXCLUDE = 'I')) order by person_number What's the issue here?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!