VIEW: APPS.HXT_ROLLBACK_BATCH_REF_V

Source

View Text - Preformatted

SELECT DISTINCT pbh.batch_reference, pbh.business_group_id FROM PAY_BATCH_HEADERS PBH,HXT_BATCH_STATES HBS,HXT_TIMECARDS TIM WHERE tim.batch_id = pbh.batch_id AND hbs.status = 'VT' AND pbh.batch_reference IS NOT NULL AND hbs.batch_id = tim.batch_id AND NOT EXISTS ( SELECT 1 FROM hxt_det_hours_worked WHERE tim_id = tim.id AND retro_batch_id IS NOT NULL )

View Text - HTML Formatted

SELECT DISTINCT PBH.BATCH_REFERENCE
, PBH.BUSINESS_GROUP_ID
FROM PAY_BATCH_HEADERS PBH
, HXT_BATCH_STATES HBS
, HXT_TIMECARDS TIM
WHERE TIM.BATCH_ID = PBH.BATCH_ID
AND HBS.STATUS = 'VT'
AND PBH.BATCH_REFERENCE IS NOT NULL
AND HBS.BATCH_ID = TIM.BATCH_ID
AND NOT EXISTS ( SELECT 1
FROM HXT_DET_HOURS_WORKED
WHERE TIM_ID = TIM.ID
AND RETRO_BATCH_ID IS NOT NULL )