View: PA_JOBS_RES_V

Product:	PA - Projects
Description:	10Sc Only
Implementation/DBA Data:	APPS.PA_JOBS_RES_V

View Text

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

Columns