Product: | PAY - Payroll |
---|---|
Description: | |
Implementation/DBA Data: | APPS.PAYBV_PAYROLL |
SELECT PRL.PAYROLL_NAME
, PRL.EFFECTIVE_START_DATE
, PRL.EFFECTIVE_END_DATE
, PRL.PERIOD_TYPE
, PRL.CUT_OFF_DATE_OFFSET
, PRL.DIRECT_DEPOSIT_DATE_OFFSET
, PRL.FIRST_PERIOD_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRL.NEGATIVE_PAY_ALLOWED_FLAG) NEGATIVE_PAY_ALLOWED_FLAG
, PRL.NUMBER_OF_YEARS
, PRL.PAY_ADVICE_DATE_OFFSET
, PRL.PAY_DATE_OFFSET
, PRL.MIDPOINT_OFFSET
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRL.ARREARS_FLAG) ARREARS_FLAG
, HR_BIS.BIS_DECODE_LOOKUP('PAYROLL_TYPE'
, PRL.PAYROLL_TYPE) PAYROLL_TYPE
, '_DF:PAY:PAY_PAYROLLS:PRL'
, 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
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, PRL.MULTI_ASSIGNMENTS_FLAG) MULTI_ASSIGNMENTS_FLAG
, PRL.NEGATIVE_PAY_ALLOWED_FLAG NEGATIVE_PAY_ALLOWED_FLAG_CODE
, PRL.ARREARS_FLAG ARREARS_FLAG_CODE
, PRL.PAYROLL_TYPE PAYROLL_TYPE_CODE
, PRL.MULTI_ASSIGNMENTS_FLAG MULTI_ASSIGNMENTS_FLAG_CODE
, PRL.PAYROLL_ID
, PRL.DEFAULT_PAYMENT_METHOD_ID
, PRL.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.ORGANIZATION_ID
, PRL.COMMENT_ID
, PRL.PERIOD_RESET_YEARS
, PRL.LAST_UPDATE_DATE
, PRL.LAST_UPDATE_LOGIN
, PRL.LAST_UPDATED_BY
, PRL.CREATED_BY
, PRL.CREATION_DATE
, CASE WHEN (PRL.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID
, PRL.BUSINESS_GROUP_ID)) THEN 'Y' ELSE 'N' END BG_SECURITY_FLAG_CODE
FROM PAY_PAYROLLS_F PRL WITH READ ONLY