VIEW: APPS.HXT_RBCK_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 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) )

View Text - HTML Formatted

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