ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713C51A9E05362FB09050512Y SELECT ppa_p30.payroll_action_id report_id, NULL payroll_id, paa_p30.assignment_id assignment_id, pact_er.action_information5 employer_paye_number, pact_er.action_information4 tax_district_number, pap.full_name employee_name, MAX (pact_ee.action_information4) prsi_number , PAY_PAYIEP30_XMLP_PKG.cf_payroll_nameformula(NULL) CF_Payroll_Name, PAY_PAYIEP30_XMLP_PKG.cf_calculate_total_prsiformula(ppa_p30.payroll_action_id, paa_p30.assignment_id) CF_CALCULATE_TOTAL_PRSI, PAY_PAYIEP30_XMLP_PKG.CP_PAYE_YTD_p CP_PAYE_YTD, PAY_PAYIEP30_XMLP_PKG.CP_EE_PRSI_YTD_p CP_EE_PRSI_YTD, PAY_PAYIEP30_XMLP_PKG.CP_ER_PRSI_YTD_p CP_ER_PRSI_YTD, PAY_PAYIEP30_XMLP_PKG.CP_TOTAL_PRSI_REPORT_p CP_TOTAL_PRSI_REPORT, PAY_PAYIEP30_XMLP_PKG.CP_TOTAL_PRSI_YTD_p CP_TOTAL_PRSI_YTD, PAY_PAYIEP30_XMLP_PKG.CP_PAYE_PTD_p CP_PAYE_PTD, PAY_PAYIEP30_XMLP_PKG.CP_EE_PRSI_PTD_p CP_EE_PRSI_PTD, PAY_PAYIEP30_XMLP_PKG.CP_ER_PRSI_PTD_p CP_ER_PRSI_PTD FROM pay_payroll_actions ppa_p30, pay_assignment_actions paa_p30, per_all_assignments_f paa, per_all_people_f pap, pay_action_interlocks pai_p30, pay_assignment_actions paa_arc, pay_action_interlocks pai_arc, pay_assignment_actions paa_prepay, pay_action_interlocks pai_prepay, pay_action_information pact_er, pay_action_information pact_ee, per_periods_of_service pps WHERE ppa_p30.payroll_action_id = :p_p30_action_id AND ppa_p30.payroll_action_id = paa_p30.payroll_action_id AND paa_p30.assignment_id = paa.assignment_id AND paa.person_id = pap.person_id AND pps.person_id = pap.person_id AND NVL (pps.actual_termination_date, nvl ( ppa_p30.date_earned , ppa_p30.effective_date )) BETWEEN pap.effective_start_date AND pap.effective_end_date AND NVL (pps.actual_termination_date, nvl ( ppa_p30.date_earned , ppa_p30.effective_date )) BETWEEN paa.effective_start_date AND paa.effective_end_date /* AND NVL (pps.actual_termination_date, ppa_p30.date_earned) BETWEEN pap.effective_start_date AND pap.effective_end_date AND NVL (pps.actual_termination_date, ppa_p30.date_earned) BETWEEN paa.effective_start_date AND paa.effective_end_date */ AND paa_p30.assignment_action_id = pai_p30.locking_action_id AND paa_arc.assignment_action_id = pai_p30.locked_action_id AND paa_arc.assignment_action_id = pai_arc.locking_action_id AND paa_prepay.assignment_action_id = pai_arc.locked_action_id AND paa_prepay.assignment_action_id = pai_prepay.locking_action_id AND pact_er.action_context_type = 'PA' AND pact_er.action_information_category = 'EMEA PAYROLL INFO' AND pact_er.action_context_id = paa_arc.payroll_action_id AND pact_er.action_information1 = paa_prepay.payroll_action_id AND pact_ee.action_information_category = 'EMPLOYEE DETAILS' AND pact_ee.action_context_id = paa_arc.assignment_action_id /* Bug 17918968 Start */ AND pps.period_of_service_id = paa.period_of_service_id AND paa.assignment_type = 'E' AND paa.primary_flag = 'Y' /* Bug 17918968 End */ GROUP BY ppa_p30.payroll_action_id, NULL, paa_p30.assignment_id, pact_er.action_information5, pact_er.action_information4, pap.full_name PAY PAYIEP30_XML US PAY IE P30 Imported from BI Publisher Description: P30 Report Application: Payroll Source: IE P30 Report (XML) Short Name: PAYIEP30_XML DB package: PAY_PAYIEP30_XMLP_PKG BI Publisher :cp_ee_prsi_ptd :cp_ee_prsi_ytd :cp_er_prsi_ptd :cp_er_prsi_ytd :cp_order_by :cp_paye_ptd :cp_paye_ytd :cp_payroll_id :cp_report_date :cp_supplementary_run :cp_tax_start_date :cp_total_prsi_report :cp_total_prsi_ytd :format_mask :lp_report_date :lp_report_mode :lp_supplementary_run :p_business_group_id :p_conc_request_id :p_end_date :p_end_date1 :p_p30_action_id :p_report_date :p_report_mode :p_sort_by :p_start_date :p_start_date1 :p_supplementary_run 1 -30 :dummy Char select DECODE(:$flex$.report_mode:NULL,NULL,NULL,'DETAIL','DETAIL') from dual US DUMMY Dummy 2 -20 :p_report_date Date select effective_date from fnd_sessions where session_id=USERENV('SESSIONID') US Report Date Report Date 3 10 :p_p30_action_id LOV Oracle PY_IE_P30_END_DATE Y select ppa.payroll_action_id id, to_char(to_date(substr(ppa.legislative_parameters,instr(ppa.legislative_parameters,'END_DATE=')+9,10),'YYYY/MM/DD'),'DD-MON-YYYY')||'('||ppa.payroll_action_id||')' value, null description from pay_payroll_actions ppa,hr_lookups hr_lkp,pay_consolidation_sets pcs where ppa.business_group_id=fnd_global.per_business_group_id and ppa.report_type='IEP30_PRGLOCK' and ppa.action_type='X' and hr_lkp.lookup_type='ACTION_TYPE' and hr_lkp.lookup_code=action_type and pcs.consolidation_set_id (+)=ppa.consolidation_set_id order by ppa.effective_date desc, ppa.report_qualifier, ppa.action_sequence desc Y US P30 Data Lock Process P30 Data Lock Process 4 20 :p_supplementary_run LOV Oracle Yes_No Y select lookup_code id, meaning value, null description from fnd_lookups where fnd_lookups.lookup_type='YES_NO' order by value,description N Y US Supplementary Run Supplementary Run 5 30 :p_report_mode LOV Oracle PY_IE_P30_REPORT_MODE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='IE_P30_REPORT_MODE' order by value,description DETAIL Y US Report Mode Report Mode 6 40 :p_sort_by LOV Oracle PY_IE_P30_SORT_MODE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='IE_P30_SORT_MODE' and :$flex$.dummy is not null order by value,description Employee US Sort By Sort By