ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713851A9E05362FB09050512 select 'X' Dummy_Break, substr(ppttl.payment_type_name,1,14) Payment_Method_Type, substr(ppttl.payment_type_name,1,14) || ' Totals' Payment_Method_Type_Total, substr(popmftl.org_payment_method_name,1,35) Name, substr(pea.segment3,1,6) Source_Sort_Code, substr(pea.segment4,1,12) Account_Number, substr(pea.segment5,1,20) Account_Name, sum(to_number(ppp.value)) Amount, count(ppp.value) Total_Assignments_Paid, PAY_PAYGBPAY_XMLP_PKG.CP_Running_Total_Number_Paid_p CP_Running_Total_Number_Paid, PAY_PAYGBPAY_XMLP_PKG.CP_Running_Total_Amount_Paid_p CP_Running_Total_Amount_Paid, PAY_PAYGBPAY_XMLP_PKG.cf_calculate_running_totalform(:CS_Running_Total_Amount_Paid) CF_Running_Total_Amount_Paid, PAY_PAYGBPAY_XMLP_PKG.cf_running_total_number_paidfo(count ( ppp.value )) CF_Running_Total_Number_Paid from pay_payroll_actions ppa, pay_assignment_actions paa, pay_pre_payments ppp, pay_org_payment_methods_f popmf, pay_org_payment_methods_f_tl popmftl, pay_payment_types ppt, pay_payment_types_tl ppttl, pay_external_accounts pea where ppt.payment_type_id = ppttl.payment_type_id and ppttl.language = userenv('LANG') and popmf.org_payment_method_id = popmftl.org_payment_method_id and popmftl.language = userenv('LANG') and ppa.payroll_action_id = paa.payroll_action_id &P_CONSOLIDATION_SET_LINE and ppa.action_type in ('U', 'P') and ppa.action_status = 'C' and ppa.payroll_id = :P_PAYROLL_ID and ppa.EFFECTIVE_DATE between :P_PAYMENT_START_DATE and :P_PAYMENT_END_DATE and ppa.effective_date between popmf.effective_start_date and popmf.effective_end_date and paa.assignment_action_id = ppp.assignment_action_id and ppp.org_payment_method_id = popmf.org_payment_method_id and popmf.payment_type_id = ppt.payment_type_id and popmf.external_account_id = pea.external_account_id group by ppttl.payment_type_name, popmftl.org_payment_method_name, pea.segment3, pea.segment4, pea.segment5, ppa.consolidation_set_id, ppa.effective_date, popmf.effective_start_date, popmf.effective_end_date order by 1,3,2,4,5,6,7,8,9 Y PAY PAYGBPAY_XML US PAY Payments Summary Report (GB) Imported from BI Publisher Description: Payments Summary Report (GB Version) Application: Payroll Source: Payments Summary Report (GB) (XML) Short Name: PAYGBPAY_XML DB package: PAY_PAYGBPAY_XMLP_PKG BI Publisher &p_consolidation_set_line :cp_business_group_name :cp_consolidation_set_line :cp_consolidation_set_name :cp_earliest_payment :cp_latest_payment :cp_payroll_name :cp_running_total_amount_paid :cp_running_total_number_paid :cs_running_total_amount_paid :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_consolidation_set_line :p_legislation_code :p_payment_end_date :p_payment_start_date :p_payroll_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 10 :p_payroll_id LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y US Payroll Payroll Name 3 20 :p_payment_start_date Date Y US PY_SRS_GB_PAYSUM_START Earliest Payment Start Date 4 30 :p_payment_end_date Date Y US PY_SRS_GB_PAYSUM_END Latest Payment Start Date 5 40 :p_consolidation_set_id LOV Oracle PY_SRS_GB_PAYSUM_CONSOLIDATION_SET Y select con.consolidation_set_id id, con.consolidation_set_name value, null description from pay_consolidation_sets con where con.business_group_id=fnd_global.per_business_group_id and exists ( select 1 from pay_payroll_actions pact where pact.consolidation_set_id=con.consolidation_set_id and pact.payroll_id=:$flex$.py_srs_payroll and pact.effective_date between fnd_date.canonical_to_date(:$flex$.py_srs_gb_paysum_start) and fnd_date.canonical_to_date(:$flex$.py_srs_gb_paysum_end) and pact.action_type in ('R','Q','P','U') ) order by con.consolidation_set_name US Consolidation Set Consolidation Set Name :$flex$.py_srs_gb_paysum_end PY_SRS_GB_PAYSUM_END Y Consolidation Set :$flex$.py_srs_gb_paysum_start PY_SRS_GB_PAYSUM_START Y Consolidation Set :$flex$.py_srs_payroll Payroll Consolidation Set