VIEW: APPS.PAY_PAYROLLS_V2

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'