ECC Human Resources, Human Resources, SQL8

Description
Categories: Enterprise Command Center
Columns: Ecc Spec Id, Person Id, Com Effective Date From, Com Effective Date To, Logged User Id, Security Profile Id, Com Last Update Date, Us Competency Name ...
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
select
x.*
from
(
select * from (SELECT ECC_SPEC_ID
    ,PERSON_ID
               ,COMPETENCY_NAME
               ,COM_EFFECTIVE_DATE_FROM
               ,COM_EFFECTIVE_DATE_TO
    ,LOGGED_USER_ID
    ,SECURITY_PROFILE_ID
               ,COM_LAST_UPDATE_DATE
,LANGUAGE
FROM PER_ECC_COMPETENCY_V where language in ('US')) PIVOT (max(COMPETENCY_NAME) as COMPETENCY_NAME for LANGUAGE in ('US' "US"))
) x
where
2=2
Parameter Name SQL text Validation
Security Profile
x.security_profile_id in (select psp.security_profile_id from per_security_profiles psp where psp.security_profile_name=:security_profile)
LOV