VIEW: APPS.BEN_CWB_CHANGE_REASON_V

Source

View Text - Preformatted

SELECT hl.meaning chg_rsn_meaning, hl.lookup_code chg_rsn_code FROM hr_lookups hl, (SELECT COUNT (cwb.lookup_code) rsncount FROM hr_lookups cwb WHERE cwb.lookup_type = 'EMP_ASSIGN_REASON' AND cwb.enabled_flag = 'Y' AND TRUNC (SYSDATE) BETWEEN NVL (cwb.start_date_active, TRUNC (SYSDATE) ) AND NVL (cwb.end_date_active, TRUNC (SYSDATE) ) AND cwb.lookup_code LIKE '%CWB%') vld WHERE hl.lookup_type = 'EMP_ASSIGN_REASON' AND hl.enabled_flag = 'Y' AND TRUNC (SYSDATE) BETWEEN NVL (hl.start_date_active, TRUNC (SYSDATE)) AND NVL (hl.end_date_active, TRUNC (SYSDATE)) AND (hl.lookup_code LIKE '%CWB%' OR vld.rsncount = 0) ORDER BY hl.meaning

View Text - HTML Formatted

SELECT HL.MEANING CHG_RSN_MEANING
, HL.LOOKUP_CODE CHG_RSN_CODE
FROM HR_LOOKUPS HL
, (SELECT COUNT (CWB.LOOKUP_CODE) RSNCOUNT
FROM HR_LOOKUPS CWB
WHERE CWB.LOOKUP_TYPE = 'EMP_ASSIGN_REASON'
AND CWB.ENABLED_FLAG = 'Y'
AND TRUNC (SYSDATE) BETWEEN NVL (CWB.START_DATE_ACTIVE
, TRUNC (SYSDATE) )
AND NVL (CWB.END_DATE_ACTIVE
, TRUNC (SYSDATE) )
AND CWB.LOOKUP_CODE LIKE '%CWB%') VLD
WHERE HL.LOOKUP_TYPE = 'EMP_ASSIGN_REASON'
AND HL.ENABLED_FLAG = 'Y'
AND TRUNC (SYSDATE) BETWEEN NVL (HL.START_DATE_ACTIVE
, TRUNC (SYSDATE))
AND NVL (HL.END_DATE_ACTIVE
, TRUNC (SYSDATE))
AND (HL.LOOKUP_CODE LIKE '%CWB%' OR VLD.RSNCOUNT = 0) ORDER BY HL.MEANING