Product: | PSP - Labor Distribution |
---|---|
Description: | |
Implementation/DBA Data: | Not implemented in this database |
SELECT PEP.ENC_PAYROLL_ID
, PEP.BUSINESS_GROUP_ID
, HOU.NAME BUSINESS_GRP_NAME
, PEP.SET_OF_BOOKS_ID
, GL.NAME SET_OF_BOOKS_NAME
, PEP.PAYROLL_ID
, PAP.PAYROLL_NAME
, '_LA:PEP.INC_EXC_FLAG:FND_LOOKUPS:YES_NO:MEANING'
, PEP.LAST_UPDATE_DATE
, PEP.LAST_UPDATED_BY
, PEP.LAST_UPDATE_LOGIN
, PEP.CREATED_BY
, PEP.CREATION_DATE
FROM PSP_ENC_PAYROLLS PEP
, HR_ORGANIZATION_UNITS HOU
, GL_SETS_OF_BOOKS GL
, PAY_ALL_PAYROLLS_F PAP
WHERE PEP.PAYROLL_ID = PAP.PAYROLL_ID
AND PEP.BUSINESS_GROUP_ID = HOU.ORGANIZATION_ID
AND PEP.SET_OF_BOOKS_ID = GL.SET_OF_BOOKS_ID WITH READ ONLY