VIEW: APPS.PER_SUCCESSION_PLANNING_V

Source

View Text - Preformatted

SELECT psp.SUCCESSION_PLAN_ID , psp.PERSON_ID , psp.POSITION_ID , psp.BUSINESS_GROUP_ID , psp.START_DATE , psp.TIME_SCALE , psp.END_DATE , psp.AVAILABLE_FOR_PROMOTION , psp.MANAGER_COMMENTS , psp.OBJECT_VERSION_NUMBER , psp.ATTRIBUTE_CATEGORY , psp.ATTRIBUTE1 , psp.ATTRIBUTE2 , psp.ATTRIBUTE3 , psp.ATTRIBUTE4 , psp.ATTRIBUTE5 , psp.ATTRIBUTE6 , psp.ATTRIBUTE7 , psp.ATTRIBUTE8 , psp.ATTRIBUTE9 , psp.ATTRIBUTE10 , psp.ATTRIBUTE11 , psp.ATTRIBUTE12 , psp.ATTRIBUTE13 , psp.ATTRIBUTE14 , psp. ATTRIBUTE15 , psp. ATTRIBUTE16 , psp.ATTRIBUTE17 , psp.ATTRIBUTE18 , psp.ATTRIBUTE19 , psp.ATTRIBUTE20 , psp. LAST_UPDATE_DATE , psp.LAST_UPDATED_BY , psp. LAST_UPDATE_LOGIN , psp.CREATED_BY , psp.CREATION_DATE , hpf.name POSITION_NAME , ppf.full_name PERSON_FULL_NAME FROM per_succession_planning psp, per_people_f ppf, hr_positions_x hpf WHERE psp.person_id = ppf.person_id AND psp.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID') AND ppf.business_group_id = psp.business_group_id AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND hpf.business_group_id = psp.business_group_id AND psp.position_id = hpf.position_id

View Text - HTML Formatted

SELECT PSP.SUCCESSION_PLAN_ID
, PSP.PERSON_ID
, PSP.POSITION_ID
, PSP.BUSINESS_GROUP_ID
, PSP.START_DATE
, PSP.TIME_SCALE
, PSP.END_DATE
, PSP.AVAILABLE_FOR_PROMOTION
, PSP.MANAGER_COMMENTS
, PSP.OBJECT_VERSION_NUMBER
, PSP.ATTRIBUTE_CATEGORY
, PSP.ATTRIBUTE1
, PSP.ATTRIBUTE2
, PSP.ATTRIBUTE3
, PSP.ATTRIBUTE4
, PSP.ATTRIBUTE5
, PSP.ATTRIBUTE6
, PSP.ATTRIBUTE7
, PSP.ATTRIBUTE8
, PSP.ATTRIBUTE9
, PSP.ATTRIBUTE10
, PSP.ATTRIBUTE11
, PSP.ATTRIBUTE12
, PSP.ATTRIBUTE13
, PSP.ATTRIBUTE14
, PSP. ATTRIBUTE15
, PSP. ATTRIBUTE16
, PSP.ATTRIBUTE17
, PSP.ATTRIBUTE18
, PSP.ATTRIBUTE19
, PSP.ATTRIBUTE20
, PSP. LAST_UPDATE_DATE
, PSP.LAST_UPDATED_BY
, PSP. LAST_UPDATE_LOGIN
, PSP.CREATED_BY
, PSP.CREATION_DATE
, HPF.NAME POSITION_NAME
, PPF.FULL_NAME PERSON_FULL_NAME
FROM PER_SUCCESSION_PLANNING PSP
, PER_PEOPLE_F PPF
, HR_POSITIONS_X HPF
WHERE PSP.PERSON_ID = PPF.PERSON_ID
AND PSP.BUSINESS_GROUP_ID = FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND PPF.BUSINESS_GROUP_ID = PSP.BUSINESS_GROUP_ID
AND TRUNC(SYSDATE) BETWEEN PPF.EFFECTIVE_START_DATE
AND PPF.EFFECTIVE_END_DATE
AND HPF.BUSINESS_GROUP_ID = PSP.BUSINESS_GROUP_ID
AND PSP.POSITION_ID = HPF.POSITION_ID