ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4716551A9E05362FB09050512Y select &p_parameter_value parameter_value, assignment_id number_of_employees , sum(avg_sal)Average_Salary ,sum(sep_pay) Separation_pay_liability ,sum(sep_pay * 100 / liability_rate) Separation_pay ,sum(payment_days) Payment_days ,sum(working_period) Working_Period, PAY_PYKRSSEL_XMLP_PKG.cf_average_payment_daysformula(:CS_pay_days, :CS_no_of_emp) CF_Average_Payment_Days, PAY_PYKRSSEL_XMLP_PKG.cf_average_sep_payformula(:CS_sep_pay, :CS_no_of_emp) CF_Average_sep_pay, PAY_PYKRSSEL_XMLP_PKG.cf_average_working_periodformu(:CS_work_period, :CS_no_of_emp) CF_Average_working_period from pay_kr_sepl_liab_summary_v where time_period_id = :p_selection_date and payroll_id = :p_payroll and sep_pay <> 0 group by &p_parameter_value,assignment_id PAY PYKRSSEL_XML KO PAY KR 퇴직금 부채 요약 보고서 Imported from BI Publisher Description: KR 퇴직금 부채 요약 보고서 Application: Payroll Source: KR 퇴직금 부채 요약 보고서(XML) Short Name: PYKRSSEL_XML DB package: PAY_PYKRSSEL_XMLP_PKG US PAY KR Separation Pay Liability Summary Imported from BI Publisher Description: KR Separation Pay Liability Summary Report Application: Payroll Source: KR Separation Pay Liability Summary Report (XML) Short Name: PYKRSSEL_XML DB package: PAY_PYKRSSEL_XMLP_PKG BI Publisher &p_parameter_value :cp_unit :cs_no_of_emp :cs_pay_days :cs_sep_pay :cs_work_period :p_business_group_id :p_conc_request_id :p_parameter_name :p_parameter_value :p_payroll :p_period_name :p_selection_criteria :p_selection_date :p_summary_detail 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US BUSINESS_GROUP_ID 2 10 :p_payroll 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 3 20 :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 4 30 :p_selection_criteria 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 Selection Criteria