View: HXT_BATCH_REFERENCE_V

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_BATCH_REFERENCE_V

View Text

SELECT DISTINCT PBH.BATCH_REFERENCE
, PBH.BUSINESS_GROUP_ID
FROM PAY_BATCH_HEADERS PBH
, HXT_BATCH_STATES HBS
WHERE PBH.BATCH_REFERENCE IS NOT NULL
AND HBS.BATCH_ID = PBH.BATCH_ID
AND HBS.STATUS IN ('VV'
, 'VW')
AND EXISTS (SELECT 'Y'
FROM HXT_DET_HOURS_WORKED DET
WHERE DET.RETRO_BATCH_ID = HBS.BATCH_ID
AND DET.RETRO_BATCH_ID IS NOT NULL)

Columns