ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4718351A9E05362FB09050512Y select hhle.name ,ppf.per_information6 full_name ,ppf.national_identifier hkid ,ppf.per_information1 passport_number ,ppf.per_information3 work_permit_number ,to_char(to_date(ppf.per_information4,'YYYY/MM/DD HH24:MI:SS'),'DD-MON-YYYY') work_permit_expiry_date ,to_char(ppf.date_of_birth,'DD-MON-YYYY') date_of_birth ,to_char(pps.date_start,'DD-MON-YYYY') date_start from per_periods_of_service pps ,per_people_f ppf ,per_assignments_f paf ,hr_soft_coding_keyflex hscf ,hr_hk_legal_employer_v hhle where pps.person_id = paf.person_id and ppf.person_id = paf.person_id and (pps.actual_termination_date is null or (pps.actual_termination_date is not null and :p_effective_date < pps.actual_termination_date)) and paf.soft_coding_keyflex_id = hscf.soft_coding_keyflex_id and hscf.segment1 = to_char(hhle.gre_id) and paf.assignment_type = 'E' and paf.primary_flag = 'Y' and ppf.business_group_id = :p_business_group_id and pps.period_of_service_id = paf.period_of_service_id and :p_effective_date between paf.effective_start_date and paf.effective_end_date and :p_effective_date between ppf.effective_start_date and ppf.effective_end_date &cp_where_clause order by hhle.name, ppf.per_information6 PER PERHKCEL_XML US PER Employee listing (Hong Kong) Imported from BI Publisher Description: Employee list (Hong Kong) Application: Human Resources Source: Employee listing (Hong Kong) (XML) Short Name: PERHKCEL_XML DB package: PER_PERHKCEL_XMLP_PKG ZHS PER 员工列表（香港） Imported from BI Publisher Description: 员工列表（香港） Application: 人力资源管理系统 Source: 员工列表（香港）(XML) Short Name: PERHKCEL_XML DB package: PER_PERHKCEL_XMLP_PKG BI Publisher &cp_where_clause :cp_le_disp_param :cp_where_clause :p_business_group_id :p_conc_request_id :p_effective_date :p_effective_date_1 :p_legal_employer 1 -10 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id Business Group Id ZHS 业务组标识 业务组标识 2 10 :p_legal_employer LOV Oracle HR_HK_LEGAL_EMPLOYER Y select le.gre_id id, substr(le.name,1,150) value, null description from hr_hk_legal_employer_v le where le.business_group_id=fnd_global.per_business_group_id order by value,description US Legal Employer Legal Employer ZHS 合法雇主 合法雇主 3 20 :p_effective_date Date Y US Period as at Effective Date ZHS 期间截止日期 有效日期 4 30 :debugflag Char N US DebugFlag Debug Flag ZHS 调试标志 调试标志