VIEW: APPS.PER_BF_PAYMENT_DETAILS_V2

Source

View Text - Preformatted

SELECT /* Unique Attributes */ org.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 ,bpd.check_number ,bpd.payment_date ,bpd.amount ,HR_GENERAL.DECODE_LOOKUP('BACKFEED_PD_CHECK_TYPE',bpd.check_type) ,popm.org_payment_method_name ,ppt.payment_type_name ,popm.currency_code /* Foreign Key Resolutions */ /* ID's */ ,peo.person_id ,asg.assignment_id ,ppy.payroll_id ,bpr.payroll_run_id ,bpd.payment_detail_id ,ppm.personal_payment_method_id ,asg.organization_id ,asg.location_id ,asg.people_group_id ,asg.job_id ,asg.grade_id ,asg.position_id ,ppg.segment1 ,ppg.segment2 ,ppg.segment3 ,ppg.segment4 ,ppg.segment5 ,ppg.segment6 ,ppg.segment7 ,ppg.segment8 ,ppg.segment9 ,ppg.segment10 ,ppg.segment11 ,ppg.segment12 ,ppg.segment13 ,ppg.segment14 ,ppg.segment15 ,ppg.segment16 ,ppg.segment17 ,ppg.segment18 ,ppg.segment19 ,ppg.segment20 ,ppg.segment21 ,ppg.segment22 ,ppg.segment23 ,ppg.segment24 ,ppg.segment25 ,ppg.segment26 ,ppg.segment27 ,ppg.segment28 ,ppg.segment29 ,ppg.segment30 /*Descriptive Flexfield Columns*/ ,bpd.bpd_attribute_category ,bpd.bpd_attribute1 ,bpd.bpd_attribute2 ,bpd.bpd_attribute3 ,bpd.bpd_attribute4 ,bpd.bpd_attribute5 ,bpd.bpd_attribute6 ,bpd.bpd_attribute7 ,bpd.bpd_attribute8 ,bpd.bpd_attribute9 ,bpd.bpd_attribute10 ,bpd.bpd_attribute11 ,bpd.bpd_attribute12 ,bpd.bpd_attribute13 ,bpd.bpd_attribute14 ,bpd.bpd_attribute15 ,bpd.bpd_attribute16 ,bpd.bpd_attribute17 ,bpd.bpd_attribute18 ,bpd.bpd_attribute19 ,bpd.bpd_attribute20 ,bpd.bpd_attribute21 ,bpd.bpd_attribute22 ,bpd.bpd_attribute23 ,bpd.bpd_attribute24 ,bpd.bpd_attribute25 ,bpd.bpd_attribute26 ,bpd.bpd_attribute27 ,bpd.bpd_attribute28 ,bpd.bpd_attribute29 ,bpd.bpd_attribute30 FROM per_people_f peo ,pay_people_groups ppg ,per_all_assignments_f asg ,per_business_groups org ,pay_payment_types ppt ,pay_org_payment_methods_f popm ,pay_personal_payment_methods_f ppm ,per_bf_payment_details bpd ,per_bf_processed_assignments bpa ,per_bf_payroll_runs bpr ,pay_all_payrolls_f ppy WHERE org.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 ppg.people_group_id (+) = asg.people_group_id AND peo.person_id = asg.person_id AND bpa.processed_assignment_id = bpd.processed_assignment_id AND bpd.personal_payment_method_id = ppm.personal_payment_method_id AND ppm.org_payment_method_id = popm.org_payment_method_id AND popm.payment_type_id = ppt.payment_type_id AND bpr.processing_date BETWEEN asg.effective_start_date AND asg.effective_end_date AND bpr.processing_date BETWEEN popm.effective_start_date AND popm.effective_end_date AND bpr.processing_date BETWEEN ppm.effective_start_date AND ppm.effective_end_date AND bpr.processing_date BETWEEN peo.effective_start_date AND peo.effective_end_date AND bpr.processing_date BETWEEN ppy.effective_start_date AND ppy.effective_end_date WITH READ ONLY

View Text - HTML Formatted

SELECT /* UNIQUE ATTRIBUTES */ ORG.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
, BPD.CHECK_NUMBER
, BPD.PAYMENT_DATE
, BPD.AMOUNT
, HR_GENERAL.DECODE_LOOKUP('BACKFEED_PD_CHECK_TYPE'
, BPD.CHECK_TYPE)
, POPM.ORG_PAYMENT_METHOD_NAME
, PPT.PAYMENT_TYPE_NAME
, POPM.CURRENCY_CODE /* FOREIGN KEY RESOLUTIONS */ /* ID'S */
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, BPR.PAYROLL_RUN_ID
, BPD.PAYMENT_DETAIL_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
, ASG.ORGANIZATION_ID
, ASG.LOCATION_ID
, ASG.PEOPLE_GROUP_ID
, ASG.JOB_ID
, ASG.GRADE_ID
, ASG.POSITION_ID
, PPG.SEGMENT1
, PPG.SEGMENT2
, PPG.SEGMENT3
, PPG.SEGMENT4
, PPG.SEGMENT5
, PPG.SEGMENT6
, PPG.SEGMENT7
, PPG.SEGMENT8
, PPG.SEGMENT9
, PPG.SEGMENT10
, PPG.SEGMENT11
, PPG.SEGMENT12
, PPG.SEGMENT13
, PPG.SEGMENT14
, PPG.SEGMENT15
, PPG.SEGMENT16
, PPG.SEGMENT17
, PPG.SEGMENT18
, PPG.SEGMENT19
, PPG.SEGMENT20
, PPG.SEGMENT21
, PPG.SEGMENT22
, PPG.SEGMENT23
, PPG.SEGMENT24
, PPG.SEGMENT25
, PPG.SEGMENT26
, PPG.SEGMENT27
, PPG.SEGMENT28
, PPG.SEGMENT29
, PPG.SEGMENT30 /*DESCRIPTIVE FLEXFIELD COLUMNS*/
, BPD.BPD_ATTRIBUTE_CATEGORY
, BPD.BPD_ATTRIBUTE1
, BPD.BPD_ATTRIBUTE2
, BPD.BPD_ATTRIBUTE3
, BPD.BPD_ATTRIBUTE4
, BPD.BPD_ATTRIBUTE5
, BPD.BPD_ATTRIBUTE6
, BPD.BPD_ATTRIBUTE7
, BPD.BPD_ATTRIBUTE8
, BPD.BPD_ATTRIBUTE9
, BPD.BPD_ATTRIBUTE10
, BPD.BPD_ATTRIBUTE11
, BPD.BPD_ATTRIBUTE12
, BPD.BPD_ATTRIBUTE13
, BPD.BPD_ATTRIBUTE14
, BPD.BPD_ATTRIBUTE15
, BPD.BPD_ATTRIBUTE16
, BPD.BPD_ATTRIBUTE17
, BPD.BPD_ATTRIBUTE18
, BPD.BPD_ATTRIBUTE19
, BPD.BPD_ATTRIBUTE20
, BPD.BPD_ATTRIBUTE21
, BPD.BPD_ATTRIBUTE22
, BPD.BPD_ATTRIBUTE23
, BPD.BPD_ATTRIBUTE24
, BPD.BPD_ATTRIBUTE25
, BPD.BPD_ATTRIBUTE26
, BPD.BPD_ATTRIBUTE27
, BPD.BPD_ATTRIBUTE28
, BPD.BPD_ATTRIBUTE29
, BPD.BPD_ATTRIBUTE30
FROM PER_PEOPLE_F PEO
, PAY_PEOPLE_GROUPS PPG
, PER_ALL_ASSIGNMENTS_F ASG
, PER_BUSINESS_GROUPS ORG
, PAY_PAYMENT_TYPES PPT
, PAY_ORG_PAYMENT_METHODS_F POPM
, PAY_PERSONAL_PAYMENT_METHODS_F PPM
, PER_BF_PAYMENT_DETAILS BPD
, PER_BF_PROCESSED_ASSIGNMENTS BPA
, PER_BF_PAYROLL_RUNS BPR
, PAY_ALL_PAYROLLS_F PPY
WHERE ORG.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 PPG.PEOPLE_GROUP_ID (+) = ASG.PEOPLE_GROUP_ID
AND PEO.PERSON_ID = ASG.PERSON_ID
AND BPA.PROCESSED_ASSIGNMENT_ID = BPD.PROCESSED_ASSIGNMENT_ID
AND BPD.PERSONAL_PAYMENT_METHOD_ID = PPM.PERSONAL_PAYMENT_METHOD_ID
AND PPM.ORG_PAYMENT_METHOD_ID = POPM.ORG_PAYMENT_METHOD_ID
AND POPM.PAYMENT_TYPE_ID = PPT.PAYMENT_TYPE_ID
AND BPR.PROCESSING_DATE BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND BPR.PROCESSING_DATE BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE
AND BPR.PROCESSING_DATE BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.EFFECTIVE_END_DATE
AND BPR.PROCESSING_DATE BETWEEN PEO.EFFECTIVE_START_DATE
AND PEO.EFFECTIVE_END_DATE
AND BPR.PROCESSING_DATE BETWEEN PPY.EFFECTIVE_START_DATE
AND PPY.EFFECTIVE_END_DATE WITH READ ONLY