[Home] [Help]
View: EDW_HR_REC_ACT_FKV
Product: | HRI - Human Resources Intelligence (Obsolete) |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT /* $HEADER: HRIVIEW.LDT 115.3 2001/09/18 10:51:35 PKM SHIP $ */ NVL( TYP.ACTIVITY_TYPE_PK
, 'NA_EDW') || '-' || RCA.RECRUITMENT_ACTIVITY_ID || '-' || INST.INSTANCE_CODE RECRUITMENT_ACTIVITY_PK
, RCA.RECRUITMENT_ACTIVITY_ID RECRUITMENT_ACTIVITY_ID
FROM PER_RECRUITMENT_ACTIVITIES RCA
, EDW_HR_RACT_ACT_TYPE_LCV TYP
, EDW_LOCAL_INSTANCE INST
WHERE RCA.TYPE = TYP.ACTIVITY_TYPE_CODE (+)
Columns
Name |
RECRUITMENT_ACTIVITY_PK |
RECRUITMENT_ACTIVITY_ID |