ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4715B51A9E05362FB09050512Y select paf.Assignment_Number Assignment_Number ,paf.Assignment_ID Assignment_ID ,substr(ppf.first_name,1,1)||' '||substr(ppf.last_name,1,16) Full_Name ,substr(ppf.last_name,1,18) Last_Name ,rpad( substr(max(decode (prrv.input_value_id, :CP_Tax_Code_Input_Value_ID, lpad(to_char(paa.action_sequence),16,'0')||prr.source_type||lpad(to_char(prr.run_result_id),16,'0')||prrv.result_value, NULL)),34,7),7)|| ' '|| decode (substr(max(decode(prrv.input_value_id, :CP_Tax_Basis_Input_Value_ID, lpad(to_char(paa.action_sequence),16,'0')||prr.source_type||lpad(to_char(prr.run_result_id),16,'0')||prrv.result_value,NULL)),34,1),'N', '1', NULL) Tax_Code ,substr(max(decode (prrv.input_value_id, :CP_NI_Input_Value_ID, lpad(to_char(paa.action_sequence),16,'0')|| prrv.result_value, NULL)),17,1) NI_Category ,nvl(sum(decode(pbt.balance_name,'Gross Pay',prrv.result_value * pbf.scale,0)),0) Gross ,nvl(sum(decode(pbt.balance_name,'PAYE',prrv.result_value * pbf.scale,0)),0) PAYE ,nvl(sum(decode(pbt.balance_name,'Total Deductions',prrv.result_value * pbf.scale,0)),0) Total_Deductions ,nvl(sum(decode(pbt.balance_name,'Total Direct Payments',prrv.result_value * pbf.scale,0)),0) Direct_Payments ,nvl(sum(decode(pbt.balance_name,'Net Pay',prrv.result_value * pbf.scale,0)),0) Net ,nvl(sum(decode(pbt.balance_name,'NI Employer',prrv.result_value * pbf.scale,0)),0) NI_Employer ,nvl(sum(decode(pbt.balance_name,'NI Employee',prrv.result_value * pbf.scale,0)),0) NI_Employee ,max(pbt.currency_code) currency_code ,max(ppa.date_earned) date_earned ,max(ppa.payroll_id) payroll_id, PAY_PAYGBRRS_XMLP_PKG.cf_other_deductionsformula(nvl(sum(decode(pbt.balance_name,'Total Deductions',prrv.result_value * pbf.scale,0)),0),nvl(sum(decode(pbt.balance_name,'PAYE',prrv.result_value * pbf.scale,0)),0),nvl(sum(decode(pbt.balance_name,'NI Employee',prrv.result_value * pbf.scale,0)),0)) CF_Other_Deductions ,PAY_PAYGBRRS_XMLP_PKG.cf_total_paymentformula(nvl(sum(decode(pbt.balance_name,'Gross Pay',prrv.result_value * pbf.scale,0)),0),nvl(sum(decode(pbt.balance_name,'Total Deductions',prrv.result_value * pbf.scale,0)),0),nvl(sum(decode(pbt.balance_name,'Total Direct Payments',prrv.result_value * pbf.scale,0)),0)) CF_Total_Payments ,PAY_PAYGBRRS_XMLP_PKG.cf_total_payments_currencyform(max(pbt.currency_code),max(ppa.date_earned),nvl(sum(decode(pbt.balance_name,'Net Pay',prrv.result_value * pbf.scale,0)),0)) CF_NET_CURRENCY from pay_balance_feeds_f pbf ,pay_balance_types pbt ,pay_run_result_values prrv ,pay_run_results prr ,per_people_f ppf ,per_assignments_f paf ,pay_payroll_actions ppa ,pay_assignment_actions paa where ppa.payroll_id = :P_PAYROLL_ID and ppa.time_period_id = :P_TIME_PERIOD_ID &P_CONSOLIDATION_SET_LINE and paa.payroll_action_id = ppa.payroll_action_id and paa.ASSIGNMENT_ID = paf.ASSIGNMENT_ID and paf.PERSON_ID = ppf.PERSON_ID and prr.assignment_action_id= paa.assignment_action_id and pbf.balance_type_id = pbt.balance_type_id (+) and ( nvl(pbt.legislation_code,'NULL') = 'GB' or prrv.input_value_id in ( :CP_NI_Input_Value_ID, :CP_Tax_Basis_Input_Value_ID , :CP_Tax_Code_Input_Value_ID) ) and pbf.input_value_id (+) = prrv.input_value_id +0 and prr.status in ('P', 'PA') and prrv.run_result_id = prr.run_result_id and ( (pbf.input_value_id is not null and balance_name in ( 'Gross Pay', 'PAYE','Total Deductions','Total Direct Payments','Net Pay','NI Employer','NI Employee')) or ( prrv.input_value_id in ( :CP_NI_Input_Value_ID, :CP_Tax_Basis_Input_Value_ID , :CP_Tax_Code_Input_Value_ID))) and ppa.effective_date between ppf.effective_start_date and ppf.effective_end_date and ppa.effective_date between paf.effective_start_date and paf.effective_end_date group by paf.Assignment_Number ,paf.Assignment_ID ,substr(ppf.first_name,1,1)||' '||substr(ppf.last_name,1,16) ,substr(ppf.last_name,1,18) order by &CP_Sort_Order PAY PYGBERRS_XML US PAY Employee Run Results Summary Report (GB) Imported from BI Publisher Description: Employee Run Results Summary Report (GB) Application: Payroll Source: Employee Run Results Summary Report (GB) (XML) Short Name: PYGBERRS_XML DB package: PAY_PAYGBRRS_XMLP_PKG BI Publisher &cp_sort_order &p_consolidation_set_line :cp_business_group_name :cp_consolidation_set_name :cp_currency_text :cp_ni_input_value_id :cp_payroll_name :cp_sort_order :cp_tax_basis_input_value_id :cp_tax_code_input_value_id :cp_time_period_time :p_business_group :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_consolidation_set_line :p_currency_code :p_direct_payment_id :p_employer_charges_id :p_gross_pay_id :p_legislation_code :p_payroll_id :p_session_date :p_sort_order :p_time_period_id :p_total_deductions_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 Name Payroll Name 3 20 :p_time_period_id LOV Oracle PY_SRS_PAY_PERIOD_ID Y select time_period_id id, period_name value, null description from per_time_periods p,fnd_sessions f where p.payroll_id=:$flex$.py_srs_payroll and p.start_date<=f.effective_date and f.session_id= userenv('sessionid') order by p.start_date desc select ptp.period_name from per_time_periods ptp, fnd_sessions fs where ptp.payroll_id = :$flex$.payroll_name and fs.session_id = userenv('sessionid') and fs.effective_date between ptp.start_date and ptp.end_date Y US Period Payroll Time Period Name 4 30 :p_consolidation_set_id LOV Oracle PY_SRS_CONSOLIDATION_SET_PAYROLL 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, per_time_periods ptp where pact.consolidation_set_id=con.consolidation_set_id and ptp.time_period_id=:$flex$.py_srs_pay_period_id and pact.payroll_id=:$flex$.py_srs_payroll and pact.effective_date between ptp.start_date and ptp.end_date and pact.action_type in ('R','Q','P','U','V') ) order by con.consolidation_set_name US Consolidation Set Name Consolidation Set Name 5 40 :p_currency_code LOV Oracle PAY_CURRENCIES_1 Y select currency_code id, currency_code value, description description from fnd_currencies_vl where enabled_flag='Y' order by currency_code US Currency Currency 6 50 :p_sort_order LOV Oracle PY_SRS_PAY_ADVICE_LAST_SORT Y select h.lookup_code id, h.meaning value, null description from hr_lookups h where h.lookup_type='PY_SRS_PAY_ADVICE_LAST_SORT' order by value,description US Sort Order Sort Order