VIEW: APPS.HR_PATTERN_BITS_V

Source

View Text - Preformatted

SELECT PATTERN_BIT_ID , PATTERN_BIT_CODE , MEANING , TIME_UNIT_MULTIPLIER FROM HR_PATTERN_BITS , HR_LOOKUPS WHERE BASE_TIME_UNIT = LOOKUP_CODE(+) AND ((LOOKUP_CODE IS NOT NULL AND LOOKUP_TYPE = 'SCHEDULER_TIME_UNIT') OR ( LOOKUP_CODE IS NULL))

View Text - HTML Formatted

SELECT PATTERN_BIT_ID
, PATTERN_BIT_CODE
, MEANING
, TIME_UNIT_MULTIPLIER
FROM HR_PATTERN_BITS
, HR_LOOKUPS
WHERE BASE_TIME_UNIT = LOOKUP_CODE(+)
AND ((LOOKUP_CODE IS NOT NULL
AND LOOKUP_TYPE = 'SCHEDULER_TIME_UNIT') OR ( LOOKUP_CODE IS NULL))