VIEW: APPS.PAY_PAYROLLS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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