0
0
SELECT
HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ASSIGNMENT_ID AS GOAL_PLAN_ASSIGNMENT_ID,
HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ID AS GOAL_PLAN_ID,
HRG_GOAL_PLN_ASSIGNMENTS.ASSIGNMENT_ID AS ASSIGNMENT_ID,
HRG_GOAL_PLANS_TL.GOAL_PLAN_NAME AS GOAL_PLAN_NAME,
PER_ALL_PEOPLE_F.PERSON_NUMBER AS PERSON_NUMBER
FROM
FUSION.PER_ALL_PEOPLE_F PER_ALL_PEOPLE_F,
FUSION.HRG_GOAL_PLANS_TL HRG_GOAL_PLANS_TL,
FUSION.HRG_GOAL_PLN_ASSIGNMENTS HRG_GOAL_PLN_ASSIGNMENTS
WHERE
HRG_GOAL_PLN_ASSIGNMENTS.GOAL_PLAN_ID = HRG_GOAL_PLANS_TL.GOAL_PLAN_ID
AND HRG_GOAL_PLN_ASSIGNMENTS.PERSON_ID = PER_ALL_PEOPLE_F.PERSON_ID
AND HRG_GOAL_PLANS_TL.GOAL_PLAN_NAME = 'CCI - 2018 Field Services, Residential Field Tech Specialist'
AND HRG_GOAL_PLANS_TL.LANGUAGE = 'US'
I hope this blog post was helpful for you. If you have any questions or feedback, please leave a comment below.