ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713651A9E05362FB09050512Y SELECT prr.assignment_action_id assignment_action_id1, pettl.element_name, pivtl.name input_name, prr.ENTRY_TYPE, prr.status, prv.result_value, PAY_PAYGBACT_XMLP_PKG.get_ni_ptd(:ASSIGNMENT_ACTION_ID, pettl.element_name, pivtl.name) C_ptd, PAY_PAYGBACT_XMLP_PKG.get_ni_ytd(:ASSIGNMENT_ACTION_ID, pettl.element_name, pivtl.name) C_ytd FROM pay_element_types_f_tl pettl, pay_element_types_f pet, pay_element_classifications pec, pay_input_values_f_tl pivtl, pay_input_values_f piv, pay_run_result_values prv, pay_run_results prr WHERE pet.element_type_id = pettl.element_type_id and pettl.language = userenv('LANG') and piv.input_value_id = pivtl.input_value_id and pivtl.language = userenv('LANG') and prr.element_type_id = pet.element_type_id and pet.classification_id = pec.classification_id and piv.element_type_id = pet.element_type_id and prv.input_value_id = piv.input_value_id and prv.run_result_id = prr.run_result_id and :p_session_date between piv.effective_start_date and piv.effective_end_date and :p_session_date between pet.effective_start_date and pet.effective_end_date and prr.element_type_id = pet.element_type_id and pet.classification_id = pec.classification_id and piv.element_type_id = pet.element_type_id and prv.input_value_id = piv.input_value_id and prv.run_result_id = prr.run_result_id and :p_session_date between piv.effective_start_date and piv.effective_end_date and :p_session_date between pet.effective_start_date and pet.effective_end_date and prv.result_value is not null and pettl.element_name like :p_element_name and prr.assignment_action_id=:assignment_action_id union SELECT to_number(:assignment_action_id) assignment_action_id1, 'Taxable Pay', null, null, null, null, PAY_PAYGBACT_XMLP_PKG.get_ni_ptd(:ASSIGNMENT_ACTION_ID, 'Taxable Pay', null) C_ptd, PAY_PAYGBACT_XMLP_PKG.get_ni_ytd(:ASSIGNMENT_ACTION_ID, 'Taxable Pay', null) C_ytd FROM dual where :assignment_action_id = :assignment_action_id order by 1,2,3 PAY PAYGBACT_XML US PAY Payroll Actions By Person Imported from BI Publisher Description: List Payroll Actions and Results for a Person (UK) Application: Payroll Source: Payroll Actions By Person (XML) Short Name: PAYGBACT_XML DB package: PAY_PAYGBACT_XMLP_PKG BI Publisher :assignment_action_id :c_business_group_name :c_person_name :c_report_subtitle :p_business_group_id :p_conc_request_id :p_element_name :p_person_id :p_session_date :p_session_date_t :p_start_date :p_start_date_t :person_id :session_date 1 -30 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id Business Group Id 2 -20 :p_session_date Date select fnd_date.date_to_displaydate(effective_date) from fnd_sessions where session_id = userenv('sessionid') Y US PER_DATES_STANDARD Session Date 3 10 :p_person_id LOV Oracle PER_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 Person 4 20 :p_element_name Char NI% US Element Name(with wildcard) Enter Name or Partial Element Name 5 30 :p_start_date Date select hr_gbnicar.uk_tax_yr_start(effective_date) from fnd_sessions where session_id = userenv('SESSIONID') Y US Start Date Start Date