VIEW: APPS.PAY_PAYROLLS_F

Source

View Text - Preformatted

SELECT PAYROLL_ID , EFFECTIVE_START_DATE , EFFECTIVE_END_DATE , DEFAULT_PAYMENT_METHOD_ID , BUSINESS_GROUP_ID , CONSOLIDATION_SET_ID , COST_ALLOCATION_KEYFLEX_ID , SUSPENSE_ACCOUNT_KEYFLEX_ID , GL_SET_OF_BOOKS_ID , SOFT_CODING_KEYFLEX_ID , PERIOD_TYPE , ORGANIZATION_ID , CUT_OFF_DATE_OFFSET , DIRECT_DEPOSIT_DATE_OFFSET , FIRST_PERIOD_END_DATE , NEGATIVE_PAY_ALLOWED_FLAG , NUMBER_OF_YEARS , PAY_ADVICE_DATE_OFFSET , PAY_DATE_OFFSET , PAYROLL_NAME , WORKLOAD_SHIFTING_LEVEL , COMMENT_ID , MIDPOINT_OFFSET , ARREARS_FLAG , ATTRIBUTE_CATEGORY , ATTRIBUTE1 , ATTRIBUTE2 , ATTRIBUTE3 , ATTRIBUTE4 , ATTRIBUTE5 , ATTRIBUTE6 , ATTRIBUTE7 , ATTRIBUTE8 , ATTRIBUTE9 , ATTRIBUTE10 , ATTRIBUTE11 , ATTRIBUTE12 , ATTRIBUTE13 , ATTRIBUTE14 , ATTRIBUTE15 , ATTRIBUTE16 , ATTRIBUTE17 , ATTRIBUTE18 , ATTRIBUTE19 , ATTRIBUTE20 , PAYROLL_TYPE , PRL_INFORMATION_CATEGORY , PRL_INFORMATION1 , PRL_INFORMATION2 , PRL_INFORMATION3 , PRL_INFORMATION4 , PRL_INFORMATION5 , PRL_INFORMATION6 , PRL_INFORMATION7 , PRL_INFORMATION8 , PRL_INFORMATION9 , PRL_INFORMATION10 , PRL_INFORMATION11 , PRL_INFORMATION12 , PRL_INFORMATION13 , PRL_INFORMATION14 , PRL_INFORMATION15 , PRL_INFORMATION16 , PRL_INFORMATION17 , PRL_INFORMATION18 , PRL_INFORMATION19 , PRL_INFORMATION20 , PRL_INFORMATION21 , PRL_INFORMATION22 , PRL_INFORMATION23 , PRL_INFORMATION24 , PRL_INFORMATION25 , PRL_INFORMATION26 , PRL_INFORMATION27 , PRL_INFORMATION28 , PRL_INFORMATION29 , PRL_INFORMATION30 , LAST_UPDATE_DATE , LAST_UPDATED_BY , LAST_UPDATE_LOGIN , CREATED_BY , CREATION_DATE , MULTI_ASSIGNMENTS_FLAG , PERIOD_RESET_YEARS , PAYSLIP_VIEW_DATE_OFFSET FROM PAY_ALL_PAYROLLS_F PAP WHERE DECODE(HR_SECURITY.VIEW_ALL ,'Y' , 'TRUE', HR_SECURITY.SHOW_RECORD('PAY_ALL_PAYROLLS_F', PAP.PAYROLL_ID )) = 'TRUE' and decode(hr_general.get_xbg_profile,'Y', pap.business_group_id , hr_general.get_business_group_id) = pap.business_group_id AND ( NVL( PAYROLL_TYPE, 'PAYROLL' ) <> 'BENEFIT' )

View Text - HTML Formatted

SELECT PAYROLL_ID
, EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE
, DEFAULT_PAYMENT_METHOD_ID
, BUSINESS_GROUP_ID
, CONSOLIDATION_SET_ID
, COST_ALLOCATION_KEYFLEX_ID
, SUSPENSE_ACCOUNT_KEYFLEX_ID
, GL_SET_OF_BOOKS_ID
, SOFT_CODING_KEYFLEX_ID
, PERIOD_TYPE
, ORGANIZATION_ID
, CUT_OFF_DATE_OFFSET
, DIRECT_DEPOSIT_DATE_OFFSET
, FIRST_PERIOD_END_DATE
, NEGATIVE_PAY_ALLOWED_FLAG
, NUMBER_OF_YEARS
, PAY_ADVICE_DATE_OFFSET
, PAY_DATE_OFFSET
, PAYROLL_NAME
, WORKLOAD_SHIFTING_LEVEL
, COMMENT_ID
, MIDPOINT_OFFSET
, ARREARS_FLAG
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, PAYROLL_TYPE
, PRL_INFORMATION_CATEGORY
, PRL_INFORMATION1
, PRL_INFORMATION2
, PRL_INFORMATION3
, PRL_INFORMATION4
, PRL_INFORMATION5
, PRL_INFORMATION6
, PRL_INFORMATION7
, PRL_INFORMATION8
, PRL_INFORMATION9
, PRL_INFORMATION10
, PRL_INFORMATION11
, PRL_INFORMATION12
, PRL_INFORMATION13
, PRL_INFORMATION14
, PRL_INFORMATION15
, PRL_INFORMATION16
, PRL_INFORMATION17
, PRL_INFORMATION18
, PRL_INFORMATION19
, PRL_INFORMATION20
, PRL_INFORMATION21
, PRL_INFORMATION22
, PRL_INFORMATION23
, PRL_INFORMATION24
, PRL_INFORMATION25
, PRL_INFORMATION26
, PRL_INFORMATION27
, PRL_INFORMATION28
, PRL_INFORMATION29
, PRL_INFORMATION30
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, CREATED_BY
, CREATION_DATE
, MULTI_ASSIGNMENTS_FLAG
, PERIOD_RESET_YEARS
, PAYSLIP_VIEW_DATE_OFFSET
FROM PAY_ALL_PAYROLLS_F PAP
WHERE DECODE(HR_SECURITY.VIEW_ALL
, 'Y'
, 'TRUE'
, HR_SECURITY.SHOW_RECORD('PAY_ALL_PAYROLLS_F'
, PAP.PAYROLL_ID )) = 'TRUE'
AND DECODE(HR_GENERAL.GET_XBG_PROFILE
, 'Y'
, PAP.BUSINESS_GROUP_ID
, HR_GENERAL.GET_BUSINESS_GROUP_ID) = PAP.BUSINESS_GROUP_ID
AND ( NVL( PAYROLL_TYPE
, 'PAYROLL' ) <> 'BENEFIT' )