VIEW: APPS.PER_BF_EMPLOYEE_RUN_DETAILS_V

Source

View Text - Preformatted

SELECT /* Unique Attributes */ bus.name ,ppy.payroll_name ,bpr.payroll_identifier ,asg.assignment_number ,peo.employee_number /* Regular Attributes */ ,peo.full_name ,peo.current_employee_flag ,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 ,fnd_sessions ses 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 ses.session_id = userenv('sessionid') AND ses.effective_date BETWEEN peo.effective_start_date AND peo.effective_end_date AND ses.effective_date BETWEEN ppy.effective_start_date AND ppy.effective_end_date AND asg.effective_start_date = (SELECT MAX(asg2.effective_start_date) FROM per_all_assignments_f asg2 WHERE asg2.effective_start_date <= ses.effective_date AND asg2.assignment_id = asg.assignment_id) WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ BUS.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER /* REGULAR ATTRIBUTES */
, PEO.FULL_NAME
, PEO.CURRENT_EMPLOYEE_FLAG
, 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
, FND_SESSIONS SES
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 SES.SESSION_ID = USERENV('SESSIONID')
AND SES.EFFECTIVE_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND SES.EFFECTIVE_DATE BETWEEN PPY.EFFECTIVE_START_DATE
AND PPY.EFFECTIVE_END_DATE
AND ASG.EFFECTIVE_START_DATE = (SELECT MAX(ASG2.EFFECTIVE_START_DATE)
FROM PER_ALL_ASSIGNMENTS_F ASG2
WHERE ASG2.EFFECTIVE_START_DATE <= SES.EFFECTIVE_DATE
AND ASG2.ASSIGNMENT_ID = ASG.ASSIGNMENT_ID) WITH READ ONLY