[Home] [Help]
View: PAY_BATCH_HEADERS_V1
View Text
SELECT BH.BATCH_ID
, BH.BATCH_NAME
, BH.BATCH_REFERENCE
, L.MEANING BATCH_STATUS
, BH.BUSINESS_GROUP_ID
FROM PAY_BATCH_HEADERS BH
, HR_LOOKUPS L
WHERE PAY_PAYWSQEE_PKG.BATCH_OVERALL_STATUS(BH.BATCH_ID) = L.LOOKUP_CODE
AND L.LOOKUP_TYPE = 'BATCH_STATUS'
AND L.APPLICATION_ID = 800
Columns
Name |
BATCH_ID |
BATCH_NAME |
BATCH_REFERENCE |
BATCH_STATUS |
BUSINESS_GROUP_ID |