SELECT LOOKUP_CODE , MEANING , 'N' , NULL , 'N' FROM PA_LOOKUPS PL WHERE LOOKUP_TYPE = 'EVENT TYPE CLASSIFICATION' AND LOOKUP_CODE IN ('AUTOMATIC','MANUAL','WRITE OFF','WRITE ON') AND DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y',START_DATE_ACTIVE, TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
SELECT LOOKUP_CODE
, MEANING
, 'N'
, NULL
, 'N'
FROM PA_LOOKUPS PL
WHERE LOOKUP_TYPE = 'EVENT TYPE CLASSIFICATION'
AND LOOKUP_CODE IN ('AUTOMATIC'
, 'MANUAL'
, 'WRITE OFF'
, 'WRITE ON')
AND DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, START_DATE_ACTIVE
, TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE
AND NVL(END_DATE_ACTIVE
, TRUNC(SYSDATE))
|
|
|