DBA Data[Home] [Help]

VIEW: APPS.PSP_PAYROLL_SOURCE_TYPES_V

Source

View Text - Preformatted

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')