VIEW: APPS.HRFV_BACKFEED_PAYMENT_DETAILS

Source

View Text - Preformatted

SELECT org.name ,ppy.payroll_name ,bpr.payroll_identifier ,asg.assignment_number ,peo.employee_number ,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 ,'_DF:PER:PER_BF_PAYMENT_DETAILS:bpd' ,'_DF:PER:PER_BF_PROCESSED_ASSIGNMENTS:bpa' ,'_DF:PER:PER_BF_PAYROLL_RUNS:bpr' ,peo.person_id ,asg.assignment_id ,ppy.payroll_id ,bpr.payroll_run_id ,bpd.payment_detail_id ,ppm.personal_payment_method_id FROM per_people_f peo ,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 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 TRUNC(SYSDATE) BETWEEN asg.effective_start_date AND asg.effective_end_date AND TRUNC(SYSDATE) BETWEEN popm.effective_start_date AND popm.effective_end_date AND TRUNC(SYSDATE) BETWEEN ppm.effective_start_date AND ppm.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

View Text - HTML Formatted

SELECT ORG.NAME
, PPY.PAYROLL_NAME
, BPR.PAYROLL_IDENTIFIER
, ASG.ASSIGNMENT_NUMBER
, PEO.EMPLOYEE_NUMBER
, 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
, '_DF:PER:PER_BF_PAYMENT_DETAILS:BPD'
, '_DF:PER:PER_BF_PROCESSED_ASSIGNMENTS:BPA'
, '_DF:PER:PER_BF_PAYROLL_RUNS:BPR'
, PEO.PERSON_ID
, ASG.ASSIGNMENT_ID
, PPY.PAYROLL_ID
, BPR.PAYROLL_RUN_ID
, BPD.PAYMENT_DETAIL_ID
, PPM.PERSONAL_PAYMENT_METHOD_ID
FROM PER_PEOPLE_F PEO
, 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 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 TRUNC(SYSDATE) BETWEEN ASG.EFFECTIVE_START_DATE
AND ASG.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN POPM.EFFECTIVE_START_DATE
AND POPM.EFFECTIVE_END_DATE
AND TRUNC(SYSDATE) BETWEEN PPM.EFFECTIVE_START_DATE
AND PPM.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