ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713F51A9E05362FB09050512Y select uiv.organization_id ORGANIZATION_ID, substrb(hoi.org_information1,1,4) || '-' || substrb(hoi.org_information1,5,6) || '-' || substrb(hoi.org_information1,11,1) LOCATION_NUMBER, hoi.org_information5 || hoi.org_information6 || hoi.org_information7 EMPLOYER_ADDRESS, hoi.org_information9 EMPLOYER_NAME, hoi.org_information10 EMPLOYER_FULL_NAME, hoi.org_information11 EMPLOYER_TELEPHONE_NUMBER, uiv.assignment_id ASSIGNMENT_ID, uiv.person_id PERSON_ID, uiv.business_group_id BUSINESS_GROUP_ID, uiv.effective_date EFFECTIVE_DATE, uiv.report_type REPORT_TYPE, -- substrb(uiv.ui_number,1,4) || '-' || substrb(uiv.ui_number,5,6) || '-' || substrb(uiv.ui_number,11,1) -- UI_NUMBER, uiv.target_date TARGET_DATE, pp.employee_number EMPLOYEE_NUMBER, pp.per_information18 || ' ' || pp.per_information19 FULL_NAME, pp.last_name || ' ' || pp.first_name FULL_NAME_KANA, substrb(decode(pp.sex,'F','2','1'),1,1) SEX, pp.date_of_birth DATE_OF_BIRTH, uiv.qualified_status QUALIFIED_STATUS, uiv.disqualified_status DISQUALIFIED_STATUS, uiv.unemployed_issue UNEMPLOYED_ISSUE, substrb(decode(uiv.report_type, '2',pad.address_line1 || pad.address_line2 || pad.address_line3, '3',substrb(hoi2.org_information1,1,4) || '-' || substrb(hoi2.org_information1,5,6) || '-' || substrb(hoi2.org_information1,11,1), '4',hoi.org_information8, '5',pp2.per_information18 || ' ' || pp2.per_information19 || ' (' || pp2.last_name || ' ' || pp2.first_name || ')'),1,255) NOTE, PAY_PAYJPNUI_XMLP_PKG.cf_details_dummyformula(uiv.assignment_id, uiv.effective_date, uiv.target_date, pp.date_of_birth) CF_DETAILS_DUMMY, PAY_PAYJPNUI_XMLP_PKG.CP_UI_NUMBER_p CP_UI_NUMBER, PAY_PAYJPNUI_XMLP_PKG.CP_TARGET_DATE_p CP_TARGET_DATE, PAY_PAYJPNUI_XMLP_PKG.CP_DATE_OF_BIRTH_p CP_DATE_OF_BIRTH, PAY_PAYJPNUI_XMLP_PKG.CP_QUALIFIED_DATE_p CP_QUALIFIED_DATE from per_all_people_f pp2, per_all_people_f pp, hr_organization_information hoi2, hr_organization_information hoi, per_addresses pad, pay_jp_ui_v uiv where uiv.report_type=:P_REPORT_TYPE and uiv.business_group_id=:P_BUSINESS_GROUP_ID and uiv.target_date between :P_TARGET_DATE_FROM and :P_TARGET_DATE_TO and uiv.organization_id=:P_ORGANIZATION_ID &P_WHERE_CLAUSE_FOR_ASSID -- For Disqualified and pad.person_id(+)=uiv.person_id and pad.address_type(+)='JP_C' and uiv.effective_date between pad.date_from(+) and nvl(pad.date_to(+),uiv.effective_date) and hoi.organization_id=uiv.organization_id and hoi.org_information_context='JP_LI_UNION_INFO' -- For Transfer and hoi2.organization_id(+)=uiv.organization_id_from and hoi2.org_information_context(+)='JP_LI_UNION_INFO' and pp.person_id=uiv.person_id and uiv.target_date between pp.effective_start_date and pp.effective_end_date -- For Name Changed and pp2.person_id(+)=uiv.person_id and uiv.effective_date-1 between pp2.effective_start_date(+) and pp2.effective_end_date(+) order by target_date, lpad(pp.employee_number,30,' ') PAY PAYJPNUI_XML JA PAY 給与帳票(雇用保険被保険者各種チェックリスト) Imported from BI Publisher Description: 給与帳票(雇用保険被保険者各種チェックリスト) Application: Payroll Source: 給与帳票(雇用保険被保険者各種チェックリスト)(XML) Short Name: PAYJPNUI_XML DB package: PAY_PAYJPNUI_XMLP_PKG US PAY Payroll Report (Check list for Unemployment Ins) Imported from BI Publisher Description: Payroll Report (Check list for Unemployment Ins) Application: Payroll Source: Payroll Report (Check list for Unemployment Ins) (XML) Short Name: PAYJPNUI_XML DB package: PAY_PAYJPNUI_XMLP_PKG BI Publisher &p_where_clause_for_assid :cp_date_of_birth :cp_note_title :cp_output_date_global :cp_qualified_date :cp_report_title :cp_target_date :cp_target_date_title :cp_ui_number :g_qualified_date_iv_id :g_ui_number_iv_id :p_assignment_id1 :p_assignment_id10 :p_assignment_id2 :p_assignment_id3 :p_assignment_id4 :p_assignment_id5 :p_assignment_id6 :p_assignment_id7 :p_assignment_id8 :p_assignment_id9 :p_business_group_id :p_conc_request_id :p_organization_id :p_report_type :p_target_date_from :p_target_date_to :p_where_clause_for_assid 1 -20 :p_business_group_id LOV Oracle PAY_JP_SRS_BUSINESS_GROUP_ID Y select business_group_id id, name value, null description from per_business_groups where business_group_id=fnd_global.per_business_group_id order by value,description select name from per_business_groups where business_group_id=fnd_global.PER_BUSINESS_GROUP_ID Y JA PAY_JP_SRS_BUSINESS_GROUP_ID ビジネス・グループ US PAY_JP_SRS_BUSINESS_GROUP_ID Business Group 2 10 :p_report_type LOV Oracle PAY_JP_SRS_UI_REPORT_TYPE Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='JP_UI_REPORT_TYPE' order by lookup_code Y JA チェックリスト チェックリスト US Checklist Checklist 3 20 :p_target_date_from Date select fnd_date.date_to_chardate(effective_date) from fnd_sessions where session_id=userenv('sessionid') Y JA PAY_JP_SRS_DATE_LOW 対象日(自) US PAY_JP_SRS_DATE_LOW Target Date From 4 30 :p_target_date_to Date select fnd_date.date_to_chardate(effective_date) from fnd_sessions where session_id=userenv('sessionid') Y JA PAY_JP_SRS_DATE_HIGH 対象日(至) US PAY_JP_SRS_DATE_HIGH Target Date To 5 40 :p_organization_id LOV Oracle PAY_JP_SRS_LI_ORGANIZATION_ID Y select hou.organization_id id, hou.name value, null description from hr_all_organization_units_vl hou where hou.business_group_id=fnd_global.per_business_group_id and hou.organization_id in ( select hoi.organization_id from hr_organization_information hoi where hoi.organization_id=hou.organization_id and hoi.org_information_context='CLASS' and hoi.org_information1='JP_ROUDOU') order by hou.name Y JA 事業主 事業主 US Employer Employer 6 50 :p_assignment_id1 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員1 従業員1 US Employee1 Employee1 7 60 :p_assignment_id2 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員2 従業員2 US Employee2 Employee2 8 70 :p_assignment_id3 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員3 従業員3 US Employee3 Employee3 9 80 :p_assignment_id4 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員4 従業員4 US Employee4 Employee4 10 90 :p_assignment_id5 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員5 従業員5 US Employee5 Employee5 11 100 :p_assignment_id6 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員6 従業員6 US Employee6 Employee6 12 110 :p_assignment_id7 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員7 従業員7 US Employee7 Employee7 13 120 :p_assignment_id8 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員8 従業員8 US Employee8 Employee8 14 130 :p_assignment_id9 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員9 従業員9 US Employee9 Employee9 15 140 :p_assignment_id10 LOV Oracle PAY_JP_SRS_UI_ASSID Y select hrv.assignment_id id, pp.employee_number value, substrb(rpad(pp.per_information18 || ' ' || pp.per_information19,15,' ') || ' ' || fnd_date.date_to_chardate(hrv.target_date),1,100) description from per_all_people_f pp,pay_jp_ui_v hrv where hrv.business_group_id=:$flex$.pay_jp_srs_business_group_id and hrv.report_type=:$flex$.pay_jp_srs_ui_report_type and hrv.target_date between fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_low) and fnd_date.canonical_to_date(:$flex$.pay_jp_srs_date_high) and hrv.organization_id=:$flex$.pay_jp_srs_li_organization_id and pp.person_id=hrv.person_id and hrv.effective_date between pp.effective_start_date and pp.effective_end_date order by hrv.effective_date,lpad(pp.employee_number,30,' ') JA 従業員10 従業員10 US Employee10 Employee10