VIEW: HR.PER_BF_PAYROLL_RUNS#

Source

View Text - Preformatted

select PAYROLL_RUN_ID PAYROLL_RUN_ID, PAYROLL_ID PAYROLL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, PAYROLL_IDENTIFIER PAYROLL_IDENTIFIER, PERIOD_START_DATE PERIOD_START_DATE, PERIOD_END_DATE PERIOD_END_DATE, PROCESSING_DATE PROCESSING_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, BPR_ATTRIBUTE_CATEGORY BPR_ATTRIBUTE_CATEGORY, BPR_ATTRIBUTE1 BPR_ATTRIBUTE1, BPR_ATTRIBUTE2 BPR_ATTRIBUTE2, BPR_ATTRIBUTE3 BPR_ATTRIBUTE3, BPR_ATTRIBUTE4 BPR_ATTRIBUTE4, BPR_ATTRIBUTE5 BPR_ATTRIBUTE5, BPR_ATTRIBUTE6 BPR_ATTRIBUTE6, BPR_ATTRIBUTE7 BPR_ATTRIBUTE7, BPR_ATTRIBUTE8 BPR_ATTRIBUTE8, BPR_ATTRIBUTE9 BPR_ATTRIBUTE9, BPR_ATTRIBUTE10 BPR_ATTRIBUTE10, BPR_ATTRIBUTE11 BPR_ATTRIBUTE11, BPR_ATTRIBUTE12 BPR_ATTRIBUTE12, BPR_ATTRIBUTE13 BPR_ATTRIBUTE13, BPR_ATTRIBUTE14 BPR_ATTRIBUTE14, BPR_ATTRIBUTE15 BPR_ATTRIBUTE15, BPR_ATTRIBUTE16 BPR_ATTRIBUTE16, BPR_ATTRIBUTE17 BPR_ATTRIBUTE17, BPR_ATTRIBUTE18 BPR_ATTRIBUTE18, BPR_ATTRIBUTE19 BPR_ATTRIBUTE19, BPR_ATTRIBUTE20 BPR_ATTRIBUTE20, BPR_ATTRIBUTE21 BPR_ATTRIBUTE21, BPR_ATTRIBUTE22 BPR_ATTRIBUTE22, BPR_ATTRIBUTE23 BPR_ATTRIBUTE23, BPR_ATTRIBUTE24 BPR_ATTRIBUTE24, BPR_ATTRIBUTE25 BPR_ATTRIBUTE25, BPR_ATTRIBUTE26 BPR_ATTRIBUTE26, BPR_ATTRIBUTE27 BPR_ATTRIBUTE27, BPR_ATTRIBUTE28 BPR_ATTRIBUTE28, BPR_ATTRIBUTE29 BPR_ATTRIBUTE29, BPR_ATTRIBUTE30 BPR_ATTRIBUTE30 from "HR"."PER_BF_PAYROLL_RUNS"

View Text - HTML Formatted

SELECT PAYROLL_RUN_ID PAYROLL_RUN_ID
, PAYROLL_ID PAYROLL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, PAYROLL_IDENTIFIER PAYROLL_IDENTIFIER
, PERIOD_START_DATE PERIOD_START_DATE
, PERIOD_END_DATE PERIOD_END_DATE
, PROCESSING_DATE PROCESSING_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, BPR_ATTRIBUTE_CATEGORY BPR_ATTRIBUTE_CATEGORY
, BPR_ATTRIBUTE1 BPR_ATTRIBUTE1
, BPR_ATTRIBUTE2 BPR_ATTRIBUTE2
, BPR_ATTRIBUTE3 BPR_ATTRIBUTE3
, BPR_ATTRIBUTE4 BPR_ATTRIBUTE4
, BPR_ATTRIBUTE5 BPR_ATTRIBUTE5
, BPR_ATTRIBUTE6 BPR_ATTRIBUTE6
, BPR_ATTRIBUTE7 BPR_ATTRIBUTE7
, BPR_ATTRIBUTE8 BPR_ATTRIBUTE8
, BPR_ATTRIBUTE9 BPR_ATTRIBUTE9
, BPR_ATTRIBUTE10 BPR_ATTRIBUTE10
, BPR_ATTRIBUTE11 BPR_ATTRIBUTE11
, BPR_ATTRIBUTE12 BPR_ATTRIBUTE12
, BPR_ATTRIBUTE13 BPR_ATTRIBUTE13
, BPR_ATTRIBUTE14 BPR_ATTRIBUTE14
, BPR_ATTRIBUTE15 BPR_ATTRIBUTE15
, BPR_ATTRIBUTE16 BPR_ATTRIBUTE16
, BPR_ATTRIBUTE17 BPR_ATTRIBUTE17
, BPR_ATTRIBUTE18 BPR_ATTRIBUTE18
, BPR_ATTRIBUTE19 BPR_ATTRIBUTE19
, BPR_ATTRIBUTE20 BPR_ATTRIBUTE20
, BPR_ATTRIBUTE21 BPR_ATTRIBUTE21
, BPR_ATTRIBUTE22 BPR_ATTRIBUTE22
, BPR_ATTRIBUTE23 BPR_ATTRIBUTE23
, BPR_ATTRIBUTE24 BPR_ATTRIBUTE24
, BPR_ATTRIBUTE25 BPR_ATTRIBUTE25
, BPR_ATTRIBUTE26 BPR_ATTRIBUTE26
, BPR_ATTRIBUTE27 BPR_ATTRIBUTE27
, BPR_ATTRIBUTE28 BPR_ATTRIBUTE28
, BPR_ATTRIBUTE29 BPR_ATTRIBUTE29
, BPR_ATTRIBUTE30 BPR_ATTRIBUTE30
FROM "HR"."PER_BF_PAYROLL_RUNS"