View: PAY_PDT_BATCH_HEADERS

Product:	PAY - Payroll
Description:
Implementation/DBA Data:	APPS.PAY_PDT_BATCH_HEADERS

View Text

SELECT PBH.BATCH_ID
, TO_NUMBER( NULL ) PAYROLL_ID
, PBH.BUSINESS_GROUP_ID
, DECODE( PBH.BATCH_STATUS
, 'P'
, 'H'
, 'U'
, 'R'
, PBH.BATCH_STATUS) BATCH_STATUS
, L.LOOKUP_CODE BATCH_TYPE
, PBH.BATCH_REFERENCE REFERENCE_NUM
, PBH.LAST_UPDATE_DATE
, PBH.LAST_UPDATED_BY
, PBH.LAST_UPDATE_LOGIN
, PBH.CREATED_BY
, PBH.CREATION_DATE
, TO_DATE( NULL ) LAST_PROCESSED_DATE
FROM PAY_BATCH_HEADERS PBH
, HR_LOOKUPS L
WHERE PBH.COMMENTS = L.MEANING(+)
AND L.LOOKUP_TYPE(+) = 'PAY_PDT_BATCH_TYPES'
AND PBH.BATCH_NAME = 'BATCH '||TO_CHAR( PBH.BATCH_ID )

Columns