ECC Human Resources, Human Resources, SQL6

➜ Back to Library
XMLXML import file

Description

Categories
Enterprise Command Center
Imported from Enterprise Command Center
Dataset Key: PER
Query Procedure: PER_ECC_DATA_LOAD.GET_ECC_DATA_LOAD_INFO
Security Procedure: PER_ECC_DATASECURITY_PKG_PUB.GetFilterAttributeValues

SQL 16 lines

select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
    ,PERSON_ID
               ,PERFORMANCE_RATING
               ,REVIEW_DATE
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,PER_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_PERFORMANCE_V where language in ('US')) PIVOT (max(PERFORMANCE_RATING) as PERFORMANCE_RATING for LANGUAGE in ('US' "US"))
) x
where
2=2

Parameters 1

ParameterTypeList of values SQL
Security ProfileLOV
x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile)