VIEW: APPS.HR_COMPONENTLESS_PATTERNS_V

Source

View Text - Preformatted

SELECT PAT.PATTERN_NAME PATTERN_NAME , PAT.PATTERN_ID PATTERN_ID FROM HR_PATTERN_CONSTRUCTIONS CON, HR_PATTERNS PAT WHERE PAT.PATTERN_ID = CON.COMPONENT_PATTERN_ID (+) AND CON.COMPONENT_PATTERN_ID IS NULL

View Text - HTML Formatted

SELECT PAT.PATTERN_NAME PATTERN_NAME
, PAT.PATTERN_ID PATTERN_ID
FROM HR_PATTERN_CONSTRUCTIONS CON
, HR_PATTERNS PAT
WHERE PAT.PATTERN_ID = CON.COMPONENT_PATTERN_ID (+)
AND CON.COMPONENT_PATTERN_ID IS NULL