Product: | PAY - Payroll |
---|---|
Description: | View used to maintain batch header information for a PayMIX batch. |
Implementation/DBA Data: | Not implemented in this database |
SELECT PBH.ROWID ROW_ID
, PBH.BATCH_TYPE BATCH_TYPE
, L1.MEANING BATCH_TYPE_DISP
, PBH.BATCH_ID BATCH_ID
, PBH.PAYROLL_ID PAYROLL_ID
, PP.PAYROLL_NAME PAYROLL_NAME_DISP
, PBH.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, L2.MEANING BATCH_STATUS_DISP
, PBH.BATCH_STATUS BATCH_STATUS
, PBH.REFERENCE_NUM REFERENCE_NUM
, PBH.LAST_PROCESSED_DATE LAST_PROCESSED_DATE
, PBH.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PBH.LAST_UPDATED_BY LAST_UPDATED_BY
, PBH.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PBH.CREATED_BY CREATED_BY
, PBH.CREATION_DATE CREATION_DATE
FROM HR_LOOKUPS L1
, HR_LOOKUPS L2
, FND_SESSIONS FS
, PAY_ALL_PAYROLLS_F PP
, PAY_PDT_BATCH_HEADERS PBH
WHERE PBH.PAYROLL_ID = PP.PAYROLL_ID
AND L1.LOOKUP_TYPE = 'PAY_PDT_BATCH_TYPES'
AND L1.LOOKUP_CODE = PBH.BATCH_TYPE
AND L2.LOOKUP_TYPE = 'PAY_PDT_BATCH_STATES'
AND L2.LOOKUP_CODE = PBH.BATCH_STATUS
AND FS.SESSION_ID = USERENV('SESSIONID')
AND FS.EFFECTIVE_DATE BETWEEN PP.EFFECTIVE_START_DATE
AND PP.EFFECTIVE_END_DATE