ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716351A9E05362FB09050512Y Select papf.first_name first_name, nvl(&P_DERIVED_SORT_ORDER, papf.employee_number ) break_order, papf.last_name last_name, papf.employee_number employee_number, papf.national_identifier pps_number, ppa.payroll_id, pac.assignment_id, PAY_PYIEBIKA_XMLP_PKG.cf_payroll_nameformula(ppa.payroll_id) CF_Payroll_Name, PAY_PYIEBIKA_XMLP_PKG.cf_1formula(pac.assignment_id) bal1, PAY_PYIEBIKA_XMLP_PKG.cf_2formula(pac.assignment_id) bal2, PAY_PYIEBIKA_XMLP_PKG.cf_3formula(pac.assignment_id) bal3, PAY_PYIEBIKA_XMLP_PKG.cf_4formula(pac.assignment_id) bal4, PAY_PYIEBIKA_XMLP_PKG.cf_5formula(pac.assignment_id) bal5 from per_all_people_f papf, per_assignments_f paf, pay_assignment_actions pac, pay_payroll_actions ppa where papf.person_id=paf.person_id and pac.assignment_id=paf.assignment_id and papf.business_group_id=paf.business_group_id and papf.business_group_id=:P_BUSINESS_GROUP_ID and ppa.payroll_id=nvl(:P_PAYROLL_ID,ppa.payroll_id) and ppa.consolidation_set_id=:P_CONSOLIDATION_SET_ID and ppa.payroll_action_id=pac.payroll_action_id and pac.action_status='C' and ppa.action_type in ('R','Q','V','B','I') and ppa.date_earned=(select max(ppp.date_earned) from pay_payroll_actions ppp, pay_assignment_actions paas where ppp.payroll_id=ppa.payroll_id and ppp.date_earned<=:p_effective_date and ppp.action_type in ('R','Q','V','B','I') and ppp.effective_date between papf.effective_start_date and papf.effective_end_date and ppp.payroll_action_id=paas.payroll_action_id and paas.assignment_id=paf.assignment_id ) and to_number(to_char(ppa.date_earned,'YYYY')) between to_number(to_char(:p_effective_date,'YYYY'))-1 and to_number(to_char(:p_effective_date,'YYYY')) and ppa.date_earned between paf.effective_start_date and paf.effective_end_date and pac.source_action_id is null and (:p_assignment_set_id IS NULL or EXISTS ( SELECT 1 FROM hr_assignment_sets has, hr_assignment_set_amendments hasa where has.assignment_set_id=:p_assignment_set_id and nvl(has.payroll_id, ppa.payroll_id) =ppa.payroll_id and hasa.assignment_set_id = has.assignment_set_id(+) and nvl(hasa.include_or_exclude, 'I') = 'I' and nvl(hasa.assignment_id,pac.assignment_id) = pac.assignment_id ) ) PAY PYIEBIKA_XML US PAY IE BIK Arrearage Imported from BI Publisher Description: Irish Benefit in Kind Arrearage Report Application: Payroll Source: IE BIK Arrearage Report (XML) Short Name: PYIEBIKA_XML DB package: PAY_PYIEBIKA_XMLP_PKG BI Publisher &p_derived_sort_order :cp_business_group_name :cp_effective_date :cp_ie_bik_arrearage :cp_ie_bik_arrearage_recovery :cp_ie_bik_even_arrearage :cp_ie_bik_even_arrearage_rec :cp_ie_bik_odd_arrearage :cp_ie_bik_odd_arrearage_rec :p_assignment_set_id :p_assignment_set_name :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_consolidation_set_name :p_derived_sort_order :p_effective_date :p_payroll_id :p_sort_order 1 -40 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID Business Group ID 2 -30 :p_consolidation_set_name Char SELECT :$flex$.consolidation_set.VALUE FROM DUAL US Consolidation Set Name Consolidation Set Name 3 -20 :p_assignment_set_name Char SELECT :$flex$.assignment_set.VALUE FROM DUAL US Assignment Set Name Assignment Set Name 4 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 US Payroll Payroll 5 20 :p_consolidation_set_id LOV Oracle PY_SRS_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 order by con.consolidation_set_name select c.consolidation_set_name from pay_consolidation_sets c, pay_payrolls p where p.payroll_id=:$flex$.payroll and p.consolidation_set_id = c.consolidation_set_id Y US Consolidation Set Consolidation Set 6 30 :p_assignment_set_id LOV Oracle PY_SRS_PAYROLL_ASSET Y select assignment_set_id id, assignment_set_name value, null description from hr_assignment_sets where business_group_id=fnd_global.per_business_group_id and nvl(status,'A')='A' and (payroll_id=:$flex$.py_srs_payroll or payroll_id is null) order by assignment_set_name US Assignment Set Assignment Set 7 40 :p_sort_oder LOV Oracle PAY_IE_ARREARAGE_SORT Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='IE_BIK_ARREARAGE' order by value,description US Sort Order Sort Order 8 50 :p_effective_date Date Y US Effective Date Effective Date