Product: | PQH - Public Sector HR |
---|---|
Description: | Reference Template View |
Implementation/DBA Data: | APPS.PQH_REF_TEMPLATES_V |
SELECT RFT.REF_TEMPLATE_ID
, RFT.PARENT_TEMPLATE_ID
, RFT.BASE_TEMPLATE_ID
, TEM.TEMPLATE_NAME
, RFT.REFERENCE_TYPE_CD
, LP.MEANING REFERENCE_TYPE
, TEM.LEGISLATION_CODE
, RFT.LAST_UPDATE_DATE
, RFT.LAST_UPDATED_BY
, RFT.LAST_UPDATE_LOGIN
, RFT.CREATED_BY
, RFT.CREATION_DATE
, RFT.OBJECT_VERSION_NUMBER
FROM PQH_REF_TEMPLATES RFT
, PQH_TEMPLATES_VL TEM
, HR_LOOKUPS LP
WHERE RFT.BASE_TEMPLATE_ID=TEM.TEMPLATE_ID
AND RFT.REFERENCE_TYPE_CD = LP.LOOKUP_CODE
AND LP.LOOKUP_TYPE = 'PQH_REFERENCE_TYPE'