VIEW: APPS.HRBV_ABSENCE_ATTENDANCE_TYPE_V

Source

View Text - Preformatted

SELECT ABB.DATE_EFFECTIVE, ABB.NAME, ABB.ABSENCE_CATEGORY, HR_BIS.BIS_DECODE_LOOKUP('ABSENCE_CATEGORY',ABB.ABSENCE_CATEGORY), ABB.COMMENTS, ABB.DATE_END, ABB.HOURS_OR_DAYS, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS',ABB.HOURS_OR_DAYS), '_DF:PER:PER_ABSENCE_ATTENDANCE_TYPES:ABB', ABB.INCREASING_OR_DECREASING_FLAG, HR_BIS.BIS_DECODE_LOOKUP('INCREASING_OR_DECREASING',ABB.INCREASING_OR_DECREASING_FLAG), ABB.ABSENCE_ATTENDANCE_TYPE_ID, ABB.BUSINESS_GROUP_ID, ABB.INPUT_VALUE_ID, ABB.LAST_UPDATE_DATE, ABB.LAST_UPDATED_BY, ABB.CREATED_BY, ABB.CREATION_DATE, CASE WHEN ABB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, ABB.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE FROM PER_ABSENCE_ATTENDANCE_TYPES ABB WITH READ ONLY

View Text - HTML Formatted

SELECT ABB.DATE_EFFECTIVE
, ABB.NAME
, ABB.ABSENCE_CATEGORY
, HR_BIS.BIS_DECODE_LOOKUP('ABSENCE_CATEGORY'
, ABB.ABSENCE_CATEGORY)
, ABB.COMMENTS
, ABB.DATE_END
, ABB.HOURS_OR_DAYS
, HR_BIS.BIS_DECODE_LOOKUP('HOURS_OR_DAYS'
, ABB.HOURS_OR_DAYS)
, '_DF:PER:PER_ABSENCE_ATTENDANCE_TYPES:ABB'
, ABB.INCREASING_OR_DECREASING_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('INCREASING_OR_DECREASING'
, ABB.INCREASING_OR_DECREASING_FLAG)
, ABB.ABSENCE_ATTENDANCE_TYPE_ID
, ABB.BUSINESS_GROUP_ID
, ABB.INPUT_VALUE_ID
, ABB.LAST_UPDATE_DATE
, ABB.LAST_UPDATED_BY
, ABB.CREATED_BY
, ABB.CREATION_DATE
, CASE WHEN ABB.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, ABB.BUSINESS_GROUP_ID) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PER_ABSENCE_ATTENDANCE_TYPES ABB WITH READ ONLY