ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4714151A9E05362FB09050512 Select Assignment_Action_Id Assignment_Action_Id , Assignment_Action_Id_Payroll Assignment_Action_Id_Payroll , Payroll_Action_Id_Payroll Payroll_Action_Id_Payroll , First_Name||' '||Last_Name Name , Employee_Number Employee_Number , Assignment_Number Assignment_Number , Establishment_Name Establishment_Name , Run_Type_Name Run_Type_Name , Grade Grade , Kr_Grade Kr_Grade , Payroll_Name Payroll_Name , Start_Date||' - '||End_Date Period_Dates , Hire_Date Hire_Date , Paid_Date Paid_Date, PAY_PAYKRSOE_XMLP_PKG.cf_miscearningsformula(Assignment_Action_Id) CF_MiscEarnings, PAY_PAYKRSOE_XMLP_PKG.cf_mischoursformula(Assignment_Action_Id) CF_MiscHours, PAY_PAYKRSOE_XMLP_PKG.cf_miscdeductionsformula(Assignment_Action_Id) CF_MiscDeductions From Pay_Kr_Asg_Actions_v Where Payroll_Id = :P_PAYROLL_ID And Payroll_Action_Id = :P_TIME_PERIOD_ID And to_char(Organization_Id) like nvl(:P_ESTABLISHMENT_ID,'%') And to_char(Assignment_Id) like nvl(:P_ASSIGNMENT_ID,'%') Order By decode(:P_SORT_ORDER_1,'FULL_NAME',ORDER_NAME||LAST_NAME||FIRST_NAME,'ESTABLISHMENT_ID',ORGANIZATION_ID) ,decode(:P_SORT_ORDER_2,'FULL_NAME',ORDER_NAME||LAST_NAME||FIRST_NAME,'ESTABLISHMENT_ID',ORGANIZATION_ID) ,ORDER_NAME||LAST_NAME||FIRST_NAME Y PAY PAYKRSOE_XML KO PAY 급여명세서(한국) Imported from BI Publisher Description: 급여명세서(한국) Application: Payroll Source: 급여명세서(한국)(XML) Short Name: PAYKRSOE_XML DB package: PAY_PAYKRSOE_XMLP_PKG US PAY Payslip (Korea) Imported from BI Publisher Description: Payslip (Korea) Application: Payroll Source: Payslip (Korea) (XML) Short Name: PAYKRSOE_XML DB package: PAY_PAYKRSOE_XMLP_PKG BI Publisher :cp_assign_num :cp_bus_place :cp_payroll_name :cp_period :cp_runtype_period :cp_sort_option :cp_warning_message :glvar_deductions :glvar_deductions_frame_count :glvar_earnings :glvar_earnings_frame_count :glvar_hours :leavebalance :p_assignment_id :p_business_group_id :p_conc_request_id :p_establishment_id :p_payroll_id :p_sort_order_1 :p_sort_order_2 :p_time_period_id 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y KO 업무 그룹 ID 업무 그룹 ID US Business Group Id Business Group Id 2 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 Y KO 급여 급여 US Payroll Payroll 3 20 :p_time_period_id LOV Oracle PY_KR_RUN_TYPE_PERIOD Y select pac.payroll_action_id id, run_type_name||'-'||period_name||'-'||pac.payroll_action_id value, null description from pay_payroll_actions ppa,pay_assignment_actions pac,pay_run_types_f prr,per_time_periods ptp,pay_payroll_actions rppa,pay_assignment_actions rpac,pay_action_interlocks pai where ppa.payroll_id=:$flex$.py_srs_payroll and ppa.payroll_action_id=pac.payroll_action_id and ppa.action_type in ('U','P') and ppa.action_status='C' and prr.run_type_id=rpac.run_type_id and ptp.time_period_id=rppa.time_period_id and ppa.effective_date>=rppa.effective_date and rpac.assignment_id=pac.assignment_id and pac.action_status='C' and rppa.payroll_action_id=rpac.payroll_action_id and rppa.action_type in ('R','Q') and rppa.action_status='C' and pai.locked_action_id=rpac.assignment_action_id and pai.locking_action_id=pac.assignment_action_id and ppa.effective_date between prr.effective_start_date and prr.effective_end_date and ppa.effective_date between ptp.start_date and ptp.end_date and rpac.assignment_action_id=(select max(paa_locked.assignment_action_id) from pay_assignment_actions paa_locked ,pay_action_interlocks pai_locked where pai_locked.locking_action_id=(select max(paa_locking.assignment_action_id) from pay_assignment_actions paa_locking where paa_locking.payroll_action_id=ppa.payroll_action_id) and pai_locked.locked_action_id=paa_locked.assignment_action_id) order by pac.payroll_action_id desc Y KO Run Type/기간 Run Type/기간 US Run Type/Period Run Type/Period 4 30 :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 KO 사업장 사업장 US Business Place Business Place 5 40 :p_assignment_id LOV Oracle PY_KR_ASG_NUMBER Y select assignment_id id, assignment_number value, null description from per_people_f peo,per_assignments_f asg,fnd_sessions ses where asg.business_group_id=fnd_global.per_business_group_id and asg.payroll_id=:$flex$.py_srs_payroll and asg.establishment_id=:$flex$.per_kr_business_place_id and asg.person_id=peo.person_id and exists (select null from pay_assignment_actions assact ,pay_payroll_actions pact ,pay_action_interlocks pai where pact.payroll_id=:$flex$.py_srs_payroll and pact.payroll_action_id=:$flex$.py_kr_run_type_period and pact.payroll_action_id=assact.payroll_action_id and pai.locking_action_id=assact.assignment_action_id and assact.assignment_id=asg.assignment_id) and ses.session_id=userenv('sessionid') and ses.effective_date between peo.effective_start_date and peo.effective_end_date and ses.effective_date between asg.effective_start_date and asg.effective_end_date order by asg.assignment_number,last_name||' '||first_name KO 발령 번호 발령 번호 US Assignment Number Assignment Number 6 50 :p_sort_order_1 LOV Oracle PY_KR_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='KR_SOE_SORT_BY' and enabled_flag='Y' order by meaning KO 정렬 순서 1 정렬 순서 1 US Sort Order 1 Sort Order 1 7 60 :p_sort_order_2 LOV Oracle PY_KR_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='KR_SOE_SORT_BY' and enabled_flag='Y' order by meaning KO 정렬 순서 2 정렬 순서 2 US Sort Order 2 Sort Order 2 8 70 :p_sort_order_3 LOV Oracle PY_KR_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='KR_SOE_SORT_BY' and enabled_flag='Y' order by meaning KO 정렬 순서 3 정렬 순서 3 US Sort Order 3 Sort Order 3 9 80 :p_sort_order_4 LOV Oracle PY_KR_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='KR_SOE_SORT_BY' and enabled_flag='Y' order by meaning select meaning from HR_LOOKUPS where lookup_type = 'KR_SOE_SORT_BY' and lookup_code='ASSIGNMENT_NUMBER' KO 정렬 순서 4 정렬 순서 4 US Sort Order 4 Sort Order 4 :$flex$.per_kr_business_place_id Business Place Assignment Number :$flex$.py_kr_run_type_period Run Type/Period Assignment Number :$flex$.py_srs_payroll Payroll Assignment Number :$flex$.py_srs_payroll Payroll Run Type/Period