VIEW: APPS.HRBV_APPRAISAL_TEMPLATES_V

Source

View Text - Preformatted

SELECT APT.NAME, APT.DESCRIPTION, APT.INSTRUCTIONS, APT.DATE_FROM, APT.DATE_TO, APT.QUESTIONNAIRE_LANGUAGE, '_DF:PER:PER_APPRAISAL_TEMPLATES:APT', APT.APPRAISAL_TEMPLATE_ID, APT.BUSINESS_GROUP_ID, APT.ASSESSMENT_TYPE_ID, APT.RATING_SCALE_ID, APT.QUESTIONNAIRE_TEMPLATE_ID, APT.LAST_UPDATE_DATE, APT.LAST_UPDATED_BY, APT.CREATED_BY, APT.CREATION_DATE, CASE WHEN APT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, APT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_APPRAISAL_TEMPLATES APT WITH READ ONLY

View Text - HTML Formatted

SELECT APT.NAME
, APT.DESCRIPTION
, APT.INSTRUCTIONS
, APT.DATE_FROM
, APT.DATE_TO
, APT.QUESTIONNAIRE_LANGUAGE
, '_DF:PER:PER_APPRAISAL_TEMPLATES:APT'
, APT.APPRAISAL_TEMPLATE_ID
, APT.BUSINESS_GROUP_ID
, APT.ASSESSMENT_TYPE_ID
, APT.RATING_SCALE_ID
, APT.QUESTIONNAIRE_TEMPLATE_ID
, APT.LAST_UPDATE_DATE
, APT.LAST_UPDATED_BY
, APT.CREATED_BY
, APT.CREATION_DATE
, CASE WHEN APT.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, APT.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_APPRAISAL_TEMPLATES APT WITH READ ONLY