View: PER_BF_EMPLOYEE_RUN_DETAILS_V

Product:	PER - Human Resources
Description:
Implementation/DBA Data:	APPS.PER_BF_EMPLOYEE_RUN_DETAILS_V

View Text

SELECT /* UNIQUE ATTRIBUTES */ BUS.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER /* REGULAR ATTRIBUTES */
, PEO.FULL_NAME
, BPR.PERIOD_START_DATE
, BPR.PERIOD_END_DATE
, BPR.PROCESSING_DATE /* FOREIGN KEY RESOLUTIONS */ /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, BPR.PAYROLL_RUN_ID
, BPA.PROCESSED_ASSIGNMENT_ID /*DESCRIPTIVE FLEXFIELD DEFINITIONS*/
, BPA.BPA_ATTRIBUTE_CATEGORY
, BPA.BPA_ATTRIBUTE1
, BPA.BPA_ATTRIBUTE2
, BPA.BPA_ATTRIBUTE3
, BPA.BPA_ATTRIBUTE4
, BPA.BPA_ATTRIBUTE5
, BPA.BPA_ATTRIBUTE6
, BPA.BPA_ATTRIBUTE7
, BPA.BPA_ATTRIBUTE8
, BPA.BPA_ATTRIBUTE9
, BPA.BPA_ATTRIBUTE10
, BPA.BPA_ATTRIBUTE11
, BPA.BPA_ATTRIBUTE12
, BPA.BPA_ATTRIBUTE13
, BPA.BPA_ATTRIBUTE14
, BPA.BPA_ATTRIBUTE15
, BPA.BPA_ATTRIBUTE16
, BPA.BPA_ATTRIBUTE17
, BPA.BPA_ATTRIBUTE18
, BPA.BPA_ATTRIBUTE19
, BPA.BPA_ATTRIBUTE20
, BPA.BPA_ATTRIBUTE21
, BPA.BPA_ATTRIBUTE22
, BPA.BPA_ATTRIBUTE23
, BPA.BPA_ATTRIBUTE24
, BPA.BPA_ATTRIBUTE25
, BPA.BPA_ATTRIBUTE26
, BPA.BPA_ATTRIBUTE27
, BPA.BPA_ATTRIBUTE28
, BPA.BPA_ATTRIBUTE29
, BPA.BPA_ATTRIBUTE30
, BPR.BPR_ATTRIBUTE_CATEGORY
, BPR.BPR_ATTRIBUTE1
, BPR.BPR_ATTRIBUTE2
, BPR.BPR_ATTRIBUTE3
, BPR.BPR_ATTRIBUTE4
, BPR.BPR_ATTRIBUTE5
, BPR.BPR_ATTRIBUTE6
, BPR.BPR_ATTRIBUTE7
, BPR.BPR_ATTRIBUTE8
, BPR.BPR_ATTRIBUTE9
, BPR.BPR_ATTRIBUTE10
, BPR.BPR_ATTRIBUTE11
, BPR.BPR_ATTRIBUTE12
, BPR.BPR_ATTRIBUTE13
, BPR.BPR_ATTRIBUTE14
, BPR.BPR_ATTRIBUTE15
, BPR.BPR_ATTRIBUTE16
, BPR.BPR_ATTRIBUTE17
, BPR.BPR_ATTRIBUTE18
, BPR.BPR_ATTRIBUTE19
, BPR.BPR_ATTRIBUTE20
, BPR.BPR_ATTRIBUTE21
, BPR.BPR_ATTRIBUTE22
, BPR.BPR_ATTRIBUTE23
, BPR.BPR_ATTRIBUTE24
, BPR.BPR_ATTRIBUTE25
, BPR.BPR_ATTRIBUTE26
, BPR.BPR_ATTRIBUTE27
, BPR.BPR_ATTRIBUTE28
, BPR.BPR_ATTRIBUTE29
, BPR.BPR_ATTRIBUTE30
FROM PER_PEOPLE_F PEO
, PER_ALL_ASSIGNMENTS_F ASG
, PER_BUSINESS_GROUPS BUS
, PER_BF_PROCESSED_ASSIGNMENTS BPA
, PER_BF_PAYROLL_RUNS BPR
, PAY_ALL_PAYROLLS_F PPY
WHERE BUS.BUSINESS_GROUP_ID = BPR.BUSINESS_GROUP_ID
AND PPY.PAYROLL_ID = BPR.PAYROLL_ID
AND BPR.PAYROLL_RUN_ID = BPA.PAYROLL_RUN_ID
AND BPA.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID
AND PEO.PERSON_ID = ASG.PERSON_ID
AND TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPY.EFFECTIVE_START_DATE
AND PPY.EFFECTIVE_END_DATE WITH READ ONLY

Columns