SELECT DISTINCT A.SOURCE_TYPE , B.MEANING FROM PSP_PAYROLL_SOURCES A, PSP_LOOKUPS B WHERE LOOKUP_TYPE = 'PSP_SOURCE_TYPE' AND LOOKUP_CODE = A.SOURCE_TYPE AND LOOKUP_CODE IN ('N', 'P')
View Text - HTML Formatted
SELECT DISTINCT A.SOURCE_TYPE , B.MEANING FROM PSP_PAYROLL_SOURCES A , PSP_LOOKUPS B WHERE LOOKUP_TYPE = 'PSP_SOURCE_TYPE' AND LOOKUP_CODE = A.SOURCE_TYPE AND LOOKUP_CODE IN ('N' , 'P')