View: HXT_RBCK_BATCH_REF_V

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_RBCK_BATCH_REF_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 PBH.BATCH_STATUS <> 'T'
AND HBS.BATCH_ID = PBH.BATCH_ID
AND HBS.STATUS = 'VT'
AND ( EXISTS (SELECT 'Y'
FROM HXT_TIMECARDS TIM
WHERE TIM.BATCH_ID = HBS.BATCH_ID) OR EXISTS (SELECT 'Y'
FROM HXT_DET_HOURS_WORKED DET
WHERE DET.RETRO_BATCH_ID = HBS.BATCH_ID) )

Columns