VIEW: APPS.PA_JOBS_RES_V

Source

View Text - Preformatted

SELECT JOB_ID , SUBSTR(NAME,1,60) , 'Y' , 'HOURS' , 'N' , job_group_id FROM PA_JOBS_V WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y',DATE_FROM, TRUNC(SYSDATE) ) BETWEEN DATE_FROM AND NVL(DATE_TO,TRUNC(SYSDATE))

View Text - HTML Formatted

SELECT JOB_ID
, SUBSTR(NAME
, 1
, 60)
, 'Y'
, 'HOURS'
, 'N'
, JOB_GROUP_ID
FROM PA_JOBS_V
WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES
, 'Y'
, DATE_FROM
, TRUNC(SYSDATE) ) BETWEEN DATE_FROM
AND NVL(DATE_TO
, TRUNC(SYSDATE))