View: PAY_PAYROLLS_V2

Product:	PAY - Payroll
Description:	Used to support user interface
Implementation/DBA Data:	APPS.PAY_PAYROLLS_V2

View Text

SELECT PRL.ROWID ROW_ID
, PRL.PAYROLL_ID
, PRL.EFFECTIVE_START_DATE
, PRL.EFFECTIVE_END_DATE
, PRL.DEFAULT_PAYMENT_METHOD_ID
, PRL.BUSINESS_GROUP_ID + 0 BUSINESS_GROUP_ID
, PRL.CONSOLIDATION_SET_ID
, PRL.COST_ALLOCATION_KEYFLEX_ID
, PRL.SUSPENSE_ACCOUNT_KEYFLEX_ID
, PRL.GL_SET_OF_BOOKS_ID
, PRL.SOFT_CODING_KEYFLEX_ID
, PRL.PERIOD_TYPE
, TPTTL.DISPLAY_PERIOD_TYPE
, PRL.ORGANIZATION_ID
, PRL.CUT_OFF_DATE_OFFSET
, PRL.DIRECT_DEPOSIT_DATE_OFFSET
, PRL.FIRST_PERIOD_END_DATE
, PRL.MIDPOINT_OFFSET
, PRL.NEGATIVE_PAY_ALLOWED_FLAG
, PRL.NUMBER_OF_YEARS
, PRL.PAY_ADVICE_DATE_OFFSET
, PRL.PAY_DATE_OFFSET
, PRL.PAYROLL_NAME
, PRL.WORKLOAD_SHIFTING_LEVEL
, PRL.COMMENT_ID
, PRL.ATTRIBUTE_CATEGORY
, PRL.ATTRIBUTE1
, PRL.ATTRIBUTE2
, PRL.ATTRIBUTE3
, PRL.ATTRIBUTE4
, PRL.ATTRIBUTE5
, PRL.ATTRIBUTE6
, PRL.ATTRIBUTE7
, PRL.ATTRIBUTE8
, PRL.ATTRIBUTE9
, PRL.ATTRIBUTE10
, PRL.ATTRIBUTE11
, PRL.ATTRIBUTE12
, PRL.ATTRIBUTE13
, PRL.ATTRIBUTE14
, PRL.ATTRIBUTE15
, PRL.ATTRIBUTE16
, PRL.ATTRIBUTE17
, PRL.ATTRIBUTE18
, PRL.ATTRIBUTE19
, PRL.ATTRIBUTE20
, PRL.PRL_INFORMATION_CATEGORY
, PRL.PRL_INFORMATION1
, PRL.PRL_INFORMATION2
, PRL.PRL_INFORMATION3
, PRL.PRL_INFORMATION4
, PRL.PRL_INFORMATION5
, PRL.PRL_INFORMATION6
, PRL.PRL_INFORMATION7
, PRL.PRL_INFORMATION8
, PRL.PRL_INFORMATION9
, PRL.PRL_INFORMATION10
, PRL.PRL_INFORMATION11
, PRL.PRL_INFORMATION12
, PRL.PRL_INFORMATION13
, PRL.PRL_INFORMATION14
, PRL.PRL_INFORMATION15
, PRL.PRL_INFORMATION16
, PRL.PRL_INFORMATION17
, PRL.PRL_INFORMATION18
, PRL.PRL_INFORMATION19
, PRL.PRL_INFORMATION20
, PRL.PRL_INFORMATION21
, PRL.PRL_INFORMATION22
, PRL.PRL_INFORMATION23
, PRL.PRL_INFORMATION24
, PRL.PRL_INFORMATION25
, PRL.PRL_INFORMATION26
, PRL.PRL_INFORMATION27
, PRL.PRL_INFORMATION28
, PRL.PRL_INFORMATION29
, PRL.PRL_INFORMATION30
, OPMTL.ORG_PAYMENT_METHOD_NAME PAYMENT_METHOD
, CON.CONSOLIDATION_SET_NAME CONSOLIDATION_SET
, ORGTL.NAME REPORTING_ORGANIZATION
, TPT.NUMBER_PER_FISCAL_YEAR
, TPR.PERIODS_PER_PERIOD
, TPR.BASIC_PERIOD_TYPE
, PRL.ARREARS_FLAG
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATED_BY
, PRL.LAST_UPDATE_LOGIN
, PRL.CREATED_BY
, PRL.CREATION_DATE
, PRL.PAYROLL_TYPE
, PRL.MULTI_ASSIGNMENTS_FLAG
, PRL.PERIOD_RESET_YEARS
, PRL.PAYSLIP_VIEW_DATE_OFFSET
FROM PAY_ALL_PAYROLLS_F PRL
, PAY_ORG_PAYMENT_METHODS_F OPM
, PAY_ORG_PAYMENT_METHODS_F_TL OPMTL
, PAY_CONSOLIDATION_SETS CON
, HR_ALL_ORGANIZATION_UNITS_TL ORGTL
, HR_ALL_ORGANIZATION_UNITS ORG
, PER_TIME_PERIOD_TYPES TPT
, PER_TIME_PERIOD_TYPES_TL TPTTL
, PER_TIME_PERIOD_RULES TPR
, FND_SESSIONS SES
WHERE OPM.ORG_PAYMENT_METHOD_ID = OPMTL.ORG_PAYMENT_METHOD_ID (+)
AND DECODE(OPMTL.ORG_PAYMENT_METHOD_ID
, NULL
, '1'
, OPMTL.LANGUAGE) = DECODE(OPMTL.ORG_PAYMENT_METHOD_ID
, NULL
, '1'
, USERENV('LANG'))
AND ORG.ORGANIZATION_ID = ORGTL.ORGANIZATION_ID (+)
AND DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, ORGTL.LANGUAGE) = DECODE(ORGTL.ORGANIZATION_ID
, NULL
, '1'
, USERENV('LANG'))
AND CON.CONSOLIDATION_SET_ID = PRL.CONSOLIDATION_SET_ID
AND OPM.ORG_PAYMENT_METHOD_ID (+) = PRL.DEFAULT_PAYMENT_METHOD_ID
AND ORG.ORGANIZATION_ID (+) = PRL.ORGANIZATION_ID
AND TPT.PERIOD_TYPE = PRL.PERIOD_TYPE
AND TPR.NUMBER_PER_FISCAL_YEAR = TPT.NUMBER_PER_FISCAL_YEAR
AND TPT.PERIOD_TYPE = TPTTL.PERIOD_TYPE
AND TPTTL.LANGUAGE = USERENV('LANG')
AND SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PRL.EFFECTIVE_START_DATE
AND PRL.EFFECTIVE_END_DATE
AND ((OPM.ORG_PAYMENT_METHOD_ID IS NULL) OR (OPM.ORG_PAYMENT_METHOD_ID IS NOT NULL
AND SES.EFFECTIVE_DATE BETWEEN OPM.EFFECTIVE_START_DATE
AND OPM.EFFECTIVE_END_DATE))
AND DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PAY_ALL_PAYROLLS_F'
, PRL.PAYROLL_ID )) = 'TRUE'

Columns