View: PSP_ENC_PAYROLLS_V

Product:	PSP - Labor Distribution
Description:	View for setting up payrolls for labor encumbrance
Implementation/DBA Data:	APPS.PSP_ENC_PAYROLLS_V

View Text

SELECT DISTINCT A.ENC_PAYROLL_ID
, A.BUSINESS_GROUP_ID
, A.SET_OF_BOOKS_ID
, A.PAYROLL_ID
, A.INC_EXC_FLAG
, B.PAYROLL_NAME
FROM PSP_ENC_PAYROLLS A
, PAY_PAYROLLS_F B
WHERE A.PAYROLL_ID = B.PAYROLL_ID
AND A.BUSINESS_GROUP_ID = B.BUSINESS_GROUP_ID
AND A.SET_OF_BOOKS_ID=B.GL_SET_OF_BOOKS_ID
AND B.GL_SET_OF_BOOKS_ID IS NOT NULL

Columns