Product: | PQH - Public Sector HR |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PQH_CORPS_TRAININGS_V |
SELECT CORPS_DEFINITION_ID CORPS_DEFINITION_ID
, CEI.CORPS_EXTRA_INFO_ID CORPS_EXTRA_INFO_ID
, CEI.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CEI.INFORMATION_TYPE INFORMATION_TYPE
, QUA.NAME QUALIFICATION
, CEI.INFORMATION3 QUALIFICATION_ID
, ORG.NAME INSTITUTION_NAME
, CEI.INFORMATION4 INSTITUTION_ID
, CEI.INFORMATION5 TRAINING_DURATION
, CEI.INFORMATION6 TRAINING_DURATION_UOM
, HR_GENERAL.DECODE_LOOKUP('FREQUENCY'
, CEI.INFORMATION6) UOM_DESC
, HR_GENERAL.DECODE_LOOKUP('PQH_CORPS_WAYS'
, CEI.INFORMATION7) JOINING_WAY
, CEI.INFORMATION7 JOINING_WAY_CD
, CEI.INFORMATION8 MANDATORY_FLAG
FROM PQH_CORPS_EXTRA_INFO CEI
, HR_ORGANIZATION_UNITS ORG
, PER_QUALIFICATION_TYPES QUA
WHERE QUA.QUALIFICATION_TYPE_ID = CEI.INFORMATION3
AND ORG.ORGANIZATION_ID = CEI.INFORMATION4
AND CEI.INFORMATION_TYPE ='TRAINING'