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