ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4729151A9E05362FB09050512 SELECT pay.payroll_id M_PAYROLL_ID, per.person_id M_PERSON_ID, asg.assignment_id M_ASSIGNMENT_ID, mat.maternity_id M_MATERNITY_ID, per.full_name M_EMPLOYEE_NAME, per.employee_number M_EMPLOYEE_NUMBER, per.national_identifier M_NI_NUMBER, mat.mpp_start_date M_START_DATE, next_day(mat.mpp_start_date + ele_info.maximum_mpp , to_char(to_date('18/06/2005', 'DD/MM/RRRR'), 'DY')) M_END_DATE, mat.actual_birth_date M_BIRTH_DATE, mat.pay_smp_as_lump_sum M_LUMP_SUM, mat.due_date M_DUE_DATE, SSP_SHARED_BIRTH_PAY.c_sppbformula(mat.due_date, per.person_id) C_SMP, SSP_SHARED_BIRTH_PAY.C_EWC_p C_EWC, SSP_SHARED_BIRTH_PAY.C_WQ_p C_WQ, SSP_SHARED_BIRTH_PAY.C_AVG_EARNINGS_p C_AVG_EARNINGS FROM per_people_f per, ssp_maternities mat, per_assignments_f asg, pay_payrolls_f pay, ( select to_number (ele1.element_information4) * 7 MAXIMUM_MPP from pay_element_types_f ele1 where ele1.element_name = :C_ELEMENT_NAME and :p_session_date between ele1.effective_start_date and ele1.effective_end_date ) ele_info WHERE per.person_id = asg.person_id AND asg.payroll_id = pay.payroll_id AND mat.person_id = asg.person_id AND per.business_group_id = :P_BUSINESS_GROUP_ID AND pay.payroll_id = nvl(:P_PAYROLL_ID, pay.payroll_id) AND per.person_id = nvl(:P_PERSON_ID, per.person_id) AND asg.primary_flag = 'Y' AND :P_SESSION_DATE between per.effective_start_date and per.effective_end_date AND :P_SESSION_DATE between asg.effective_start_date and asg.effective_end_date AND :P_SESSION_DATE between pay.effective_start_date and pay.effective_end_date AND ( mat.spl_start_date BETWEEN :P_DATE_FROM and :P_DATE_TO OR mat.spl_end_date BETWEEN :P_DATE_FROM and :P_DATE_TO ) and mat.leave_type= :C_LEAVE_TYPE Y SSP SSPSHPBP US SSP Statutory Shared Parental Birth Pay Imported from BI Publisher Description: Statutory Paternity Adoption Pay Report Application: SSP Source: Statutory Shared Parental Birth Pay Report(XML) Short Name: SSPSHPBP DB package: SSP_SHARED_BIRTH_PAY BI Publisher :aa_p_date_from :aa_p_date_to :c_avg_earnings :c_business_group_name :c_element_name :c_ewc :c_leave_type :c_payroll_name :c_person_name :c_report_subtitle :c_report_title :c_view_name :c_wq :p_business_group_id :p_conc_request_id :p_date_from :p_date_to :p_payroll_id :p_person_id :p_session_date :p_spp_type 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Business Group ID 2 10 :p_date_from Date Y US Start Date Start Date 3 20 :p_date_to Date Y US End Date End Date 4 30 :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 US Payroll Name Payroll Name 5 40 :p_session_date Date select effective_date from fnd_sessions where session_id = userenv('SESSIONID') Y US PER_DATES_STANDARD Session Date 6 50 :p_person_id LOV Oracle SSP_ALL_PEOPLE Y select person_id id, full_name value, null description from per_people_f p where (p.business_group_id= fnd_global.per_business_group_id and ((to_date(:$flex$.per_dates_standard, 'YYYY/MM/DD HH24:MI:SS') between p.effective_start_date and p.effective_end_date) or (to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') >p.effective_end_date and p.effective_end_date= (select max(p1.effective_end_date) from per_all_people_f p1 where p1.person_id=p.person_id)) or (to_date(:$flex$.per_dates_standard,'YYYY/MM/DD HH24:MI:SS') <p.effective_start_date and p.effective_start_date=p.start_date))) order by p.full_name US Person Name Person Name :$flex$.per_dates_standard PER_DATES_STANDARD Y Person Name