VIEW: APPS.PAYBV_PAYROLL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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