ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714251A9E05362FB09050512 select element_name ,employee_name ,element_type_id ,employee_number ,date_start ,working_period ,yearly_bonus ,alr ,average_salary_me ,average_salary_ybon ,average_salary_alr ,separation_pay ,business_group_id ,time_period_id ,result_value ,assignment_id ,assignment_action_id ,separation_date ,payment_days ,cost_center ,grade_name ,establishment_name ,establishment_id ,liability_rate ,proportion, PAY_PAYKRSPL_XMLP_PKG.cf_page_totalformula(:CS_TOTAL) CF_PAGE_TOTAL, PAY_PAYKRSPL_XMLP_PKG.cf_separation_payformula(separation_pay, liability_rate) CF_SEPARATION_PAY, PAY_PAYKRSPL_XMLP_PKG.cf_average_salaryformula(average_salary_me, average_salary_ybon, average_salary_alr) CF_AVERAGE_SALARY, PAY_PAYKRSPL_XMLP_PKG.cf_format_working_periodformul(working_period, proportion, assignment_id) CF_FORMAT_WORKING_PERIOD from pay_kr_sep_liab_detail_v where business_group_id = :p_business_group_id and time_period_id = :p_selection_date and payroll_id = :p_payroll_id and establishment_id = :p_establishment_id order by employee_number,&p_selection_value,element_type_id Y PAY PAYKRSPL_XML KO PAY KR 퇴직금 부채 상세내역 보고서 Imported from BI Publisher Description: KR 퇴직금 부채 상세내역 보고서 Application: Payroll Source: KR 퇴직금 부채 상세내역 보고서(XML) Short Name: PAYKRSPL_XML DB package: PAY_PAYKRSPL_XMLP_PKG US PAY KR Separation Pay Liability Detail Imported from BI Publisher Description: KR Separation Pay Liability Detail Report Application: Payroll Source: KR Separation Pay Liability Detail Report (XML) Short Name: PAYKRSPL_XML DB package: PAY_PAYKRSPL_XMLP_PKG BI Publisher &p_selection_value :assignment_id :cp_unit :cs_total :frame_counter :p_business_group_id :p_conc_request_id :p_establishment_id :p_payroll_id :p_selection_date :p_selection_value :p_sort_by :total 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US BUSINESS_GROUP_ID 2 10 :p_establishment_id LOV Oracle PER_KR_BUSINESS_PLACE_ID Y select hou1.organization_id id, substr(hou2.name || ' - ' || hou1.name,1,255) value, hoi4.org_information2 || ' - ' || hoi2.org_information2 description from hr_organization_information hoi4,hr_organization_information hoi3,hr_organization_units hou2,hr_organization_information hoi2,hr_organization_information hoi1,hr_organization_units hou1 where hou1.business_group_id=fnd_profile.value('PER_BUSINESS_GROUP_ID') and hoi1.organization_id=hou1.organization_id and hoi1.org_information_context='CLASS' and hoi1.org_information1='KR_BUSINESS_PLACE' and hoi2.organization_id=hoi1.organization_id and hoi2.org_information_context='KR_BUSINESS_PLACE_REGISTRATION' and hou2.organization_id=to_number(hoi2.org_information10) and hoi3.organization_id=hou2.organization_id and hoi3.org_information_context='CLASS' and hoi3.org_information1='HR_LEGAL' and hoi4.organization_id=hoi3.organization_id and hoi4.org_information_context='KR_CORPORATE_INFORMATION' order by hou2.name,hou1.name Y KO 사업장명 US Business Place Name 3 20 :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 4 30 :p_selection_date LOV Oracle PY_KR_SEPL_PERIODS Y select ptp.time_period_id id, ptp.period_name value, null description from per_time_periods ptp where ptp.time_period_id in (select pa.time_period_id from pay_payroll_actions pa, pay_assignment_actions paa, pay_run_types_f prt where pa.payroll_action_id=paa.payroll_action_id and prt.run_type_id=paa.run_type_id and pa.payroll_id=:$flex$.payroll and prt.run_type_name='SEP_L') order by value,description Y KO 선택 일자 US Selection Date 5 40 :p_sort_by LOV Oracle PY_KR_SEPL_SELECTION_CRITERIA Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='KR_SEPL_SELECTION_CRITERIA' and enabled_flag='Y' order by value,description Y KO 정렬 기준 US Sort By :$flex$.payroll PAYROLL Selection Date