View: PAY_ALL_PAYROLLS

Product:	PAY - Payroll
Description:	Date-effective view.
Implementation/DBA Data:	APPS.PAY_ALL_PAYROLLS

View Text

SELECT PAYROLL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DEFAULT_PAYMENT_METHOD_ID
, BUSINESS_GROUP_ID
, CONSOLIDATION_SET_ID
, COST_ALLOCATION_KEYFLEX_ID
, SUSPENSE_ACCOUNT_KEYFLEX_ID
, GL_SET_OF_BOOKS_ID
, SOFT_CODING_KEYFLEX_ID
, PERIOD_TYPE
, ORGANIZATION_ID
, CUT_OFF_DATE_OFFSET
, DIRECT_DEPOSIT_DATE_OFFSET
, FIRST_PERIOD_END_DATE
, NEGATIVE_PAY_ALLOWED_FLAG
, NUMBER_OF_YEARS
, PAY_ADVICE_DATE_OFFSET
, PAY_DATE_OFFSET
, PAYROLL_NAME
, WORKLOAD_SHIFTING_LEVEL
, COMMENT_ID
, MIDPOINT_OFFSET
, ARREARS_FLAG
, MULTI_ASSIGNMENTS_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, PRL_INFORMATION_CATEGORY
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION4
, PRL_INFORMATION5
, PRL_INFORMATION6
, PRL_INFORMATION7
, PRL_INFORMATION8
, PRL_INFORMATION9
, PRL_INFORMATION10
, PRL_INFORMATION11
, PRL_INFORMATION12
, PRL_INFORMATION13
, PRL_INFORMATION14
, PRL_INFORMATION15
, PRL_INFORMATION16
, PRL_INFORMATION17
, PRL_INFORMATION18
, PRL_INFORMATION19
, PRL_INFORMATION20
, PRL_INFORMATION21
, PRL_INFORMATION22
, PRL_INFORMATION23
, PRL_INFORMATION24
, PRL_INFORMATION25
, PRL_INFORMATION26
, PRL_INFORMATION27
, PRL_INFORMATION28
, PRL_INFORMATION29
, PRL_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, PERIOD_RESET_YEARS
, PAYSLIP_VIEW_DATE_OFFSET
FROM PAY_ALL_PAYROLLS_F
WHERE EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE
FROM FND_SESSIONS SS
WHERE SS.SESSION_ID = USERENV('SESSIONID'))
AND EFFECTIVE_END_DATE >= (SELECT SE.EFFECTIVE_DATE
FROM FND_SESSIONS SE
WHERE SE.SESSION_ID = USERENV('SESSIONID'))

Columns