From which table can I obtain the name of the owner of a Succession Plan? — 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

From which table can I obtain the name of the owner of a Succession Plan?

in BI Publisher Learning Center

Starting from this query, i try to obtain the name of the owner plan but without results.

Can you help me with one suggestion, please?

SELECT
HP.PLAN_NAME,
HP.PLAN_TYPE,
HPC.CANDIDATE_TYPE,
PAP.PERSON_NUMBER,
PPNF_LER.FULL_NAME AS Candidate_Name

FROM
HRM_PLANS HP
JOIN HRM_PLAN_CANDIDATES HPC ON HP.PLAN_ID = HPC.PLAN_ID
JOIN PER_ALL_PEOPLE_F PAP ON PAP.PERSON_ID = HPC.PERSON_ID
JOIN HRM_PLAN_OWNERS HPO ON HPO.PERSON

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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