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.