ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713D51A9E05362FB09050512Y select /*+ ORDERED NO_MERGE(pjsbp) */ pjsbp.si_org_id loc_id, -- decode(:p_organization_context,'JP_WP_FUND_INFO', -- wp.org_information1,hoi.org_information1) loc_code1, decode(:p_organization_context,'JP_WP_FUND_INFO', wp.org_information14,hoi.org_information14) loc_code1_sign, decode(:p_organization_context,'JP_WP_FUND_INFO', wp.org_information2,hoi.org_information2) loc_code2, hoi.org_information3 loc_number, hoi.org_information4 loc_postal_code, hoi.org_information5||hoi.org_information6||hoi.org_information7 loc_address, hoi.org_information8 loc_name, hoi.org_information9 loc_er_name, hoi.org_information10 loc_er_phone, pjsbp.assignment_action_id assignment_action_id, pjsbp.assignment_id assignment_id, pp.employee_number employee_number, pjsbp.effective_date effective_date, pjsbp.date_earned date_earned, pjsbp.person_id person_id, decode(:p_sort_order, 'HI_NUMBER',decode(:p_si_submit_type, 3,decode(pjsbp.si_type, 2,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 5,decode(pjsbp.si_type, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 7,decode(pjsbp.si_type, 2,pjsbp.wp_number, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), pjsbp.hi_number), decode(:p_si_submit_type, 4,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), 6,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), pjsbp.wp_number)) ins_number, decode(:p_sort_order, 'HI_NUMBER',decode(:p_si_submit_type, 3,decode(pjsbp.si_type, 2,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 5,decode(pjsbp.si_type, 4,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 7,decode(pjsbp.si_type, 2,'WP_NUMBER', 4,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 'HI_NUMBER'), decode(:p_si_submit_type, 4,decode(pjsbp.si_type, 5,'HI_NUMBER', 'WP_NUMBER'), 6,decode(pjsbp.si_type, 5,'HI_NUMBER', 'WP_NUMBER'), 'WP_NUMBER')) sort_order, pjsbp.si_type si_type, pp.last_name last_name_kana, pp.first_name first_name_kana, pp.per_information18 last_name, pp.per_information19 first_name, pp.date_of_birth date_of_birth, PAY_PAYJPBON_XMLP_PKG.CF_DATAFormula( decode(:p_sort_order, 'HI_NUMBER',decode(:p_si_submit_type, 3,decode(pjsbp.si_type, 2,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 5,decode(pjsbp.si_type, 4,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 7,decode(pjsbp.si_type, 2,'WP_NUMBER', 4,'WP_NUMBER', 6,'WP_NUMBER', 'HI_NUMBER'), 'HI_NUMBER'), decode(:p_si_submit_type, 4,decode(pjsbp.si_type, 5,'HI_NUMBER', 'WP_NUMBER'), 6,decode(pjsbp.si_type, 5,'HI_NUMBER', 'WP_NUMBER'), 'WP_NUMBER')), pjsbp.si_type, pp.date_of_birth, pjsbp.effective_date, pjsbp.assignment_action_id, pjsbp.assignment_id, pp.per_information18, pp.per_information19, decode(:p_sort_order, 'HI_NUMBER',decode(:p_si_submit_type, 3,decode(pjsbp.si_type, 2,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 5,decode(pjsbp.si_type, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 7,decode(pjsbp.si_type, 2,pjsbp.wp_number, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), pjsbp.hi_number), decode(:p_si_submit_type, 4,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), 6,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), pjsbp.wp_number)), pp.last_name, pp.first_name ) CF_DATA, PAY_PAYJPBON_XMLP_PKG.cp_birth_date_dd_p() cp_birth_date_dd, PAY_PAYJPBON_XMLP_PKG.cp_birth_date_era_p() cp_birth_date_era, PAY_PAYJPBON_XMLP_PKG.cp_birth_date_erayymmdd_p() cp_birth_date_erayymmdd, PAY_PAYJPBON_XMLP_PKG.cp_birth_date_mm_p() cp_birth_date_mm, PAY_PAYJPBON_XMLP_PKG.cp_birth_date_yy_p() cp_birth_date_yy, PAY_PAYJPBON_XMLP_PKG.cp_bon_comp_p() cp_bon_comp, PAY_PAYJPBON_XMLP_PKG.cp_bon_comp_total_p() cp_bon_comp_total, PAY_PAYJPBON_XMLP_PKG.cp_bon_mtr_comp_p() cp_bon_mtr_comp, PAY_PAYJPBON_XMLP_PKG.cp_bon_payment_date_p() cp_bon_payment_date, PAY_PAYJPBON_XMLP_PKG.cp_bon_payment_date_dd_p() cp_bon_payment_date_dd, PAY_PAYJPBON_XMLP_PKG.cp_bon_payment_date_mm_p() cp_bon_payment_date_mm, PAY_PAYJPBON_XMLP_PKG.cp_bon_payment_date_yy_p() cp_bon_payment_date_yy, PAY_PAYJPBON_XMLP_PKG.cp_bon_payment_date_yymmdd_p() cp_bon_payment_date_yymmdd, PAY_PAYJPBON_XMLP_PKG.cp_d_birth_date_era_p() cp_d_birth_date_era, PAY_PAYJPBON_XMLP_PKG.cp_d_bon_comp_total_p() cp_d_bon_comp_total, PAY_PAYJPBON_XMLP_PKG.cp_emp_failure_item_p() cp_emp_failure_item, PAY_PAYJPBON_XMLP_PKG.cp_error_message_p() cp_error_message, PAY_PAYJPBON_XMLP_PKG.cp_exclude_p() cp_exclude, PAY_PAYJPBON_XMLP_PKG.cp_full_name_p() cp_full_name, PAY_PAYJPBON_XMLP_PKG.cp_hi_only_p() cp_hi_only, PAY_PAYJPBON_XMLP_PKG.cp_si_sex_code_p() cp_si_sex_code, PAY_PAYJPBON_XMLP_PKG.cp_wp_only_p() cp_wp_only from pay_payroll_actions ppa, pay_jp_si_bon_payment_v pjsbp, hr_organization_information wp, hr_organization_information hoi, per_all_assignments_f pa, per_all_people_f pp where ppa.payroll_action_id = :p_payroll_action_id and ppa.business_group_id = :p_business_group_id and pjsbp.business_group_id = ppa.business_group_id &p_where_clause_for_assid and pjsbp.si_org_id = :p_organization_id and ((:p_si_submit_type = 1 and pjsbp.si_type in (1,3,5,7)) or (:p_si_submit_type = 2 and pjsbp.si_type in (2,3,6,7)) or (:p_si_submit_type = 3 and pjsbp.si_type in (1,2,3,5,6,7)) or (:p_si_submit_type = 4 and pjsbp.si_type in (4,5,6,7)) or (:p_si_submit_type = 5 and pjsbp.si_type in (1,3,4,5,6,7)) or (:p_si_submit_type = 6 and pjsbp.si_type in (2,3,4,5,6,7)) or (:p_si_submit_type = 7 and pjsbp.si_type in (1,2,3,4,5,6,7))) and (( pay_core_utils.get_parameter('SI_SUM_MTD_BON', ppa.legislative_parameters) = 'N' and pjsbp.payroll_action_id = ppa.payroll_action_id) or ( pay_core_utils.get_parameter('SI_SUM_MTD_BON', ppa.legislative_parameters) = 'Y' and pjsbp.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pjsbp.si_sum_mtd_bon = 'Y')) and nvl(substrb(pay_jp_balance_pkg.get_entry_value_char( hr_jp_id_pkg.input_value_id( 'COM_SI_REPORT_INFO', 'OUTPUT_FLAG', NULL,'JP','FALSE'), pjsbp.assignment_id, pjsbp.effective_date),1,1),'N') = decode(:p_output_flag, 1,'N', 2,'Y', nvl(substrb(pay_jp_balance_pkg.get_entry_value_char( hr_jp_id_pkg.input_value_id( 'COM_SI_REPORT_INFO', 'OUTPUT_FLAG', NULL,'JP','FALSE'), pjsbp.assignment_id, pjsbp.effective_date),1,1),'N')) and not exists( select /*+ ORDERED INDEX(PPA2 PAY_PAYROLL_ACTIONS_FK6) */ null from pay_payroll_actions ppa2, pay_assignment_actions paa2 where ppa2.element_set_id = ppa.element_set_id and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa2.business_group_id = ppa.business_group_id and ppa2.action_type = 'R' and paa2.payroll_action_id = ppa2.payroll_action_id and paa2.action_status = 'C' and paa2.assignment_id = pjsbp.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON', ppa2.legislative_parameters) = pay_core_utils.get_parameter('SI_SUM_MTD_BON', ppa.legislative_parameters) and paa2.action_sequence > pjsbp.action_sequence) and wp.organization_id (+) = pjsbp.si_org_id and wp.org_information_context (+) = 'JP_WP_UNION_INFO' and hoi.organization_id (+) = pjsbp.si_org_id and hoi.org_information_context (+) = :p_organization_context and pa.assignment_id = pjsbp.assignment_id --and pa.primary_flag = 'Y'/*commented by JSAJJA as per Bug no 8435426*/ and pjsbp.effective_date /* Bonus Process Date */ between pa.effective_start_date and pa.effective_end_date and pp.person_id = pa.person_id and pjsbp.effective_date /* Bonus Process Date */ between pp.effective_start_date and pp.effective_end_date order by lpad(decode(:p_sort_order, 'HI_NUMBER',decode(:p_si_submit_type, 3,decode(pjsbp.si_type, 2,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 5,decode(pjsbp.si_type, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), 7,decode(pjsbp.si_type, 2,pjsbp.wp_number, 4,pjsbp.wp_number, 6,pjsbp.wp_number, pjsbp.hi_number), pjsbp.hi_number), decode(:p_si_submit_type, 4,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), 6,decode(pjsbp.si_type, 5,pjsbp.hi_number, pjsbp.wp_number), pjsbp.wp_number)),10,' ') PAY PAYJPBON_XML JA PAY 給与帳票(健康保険・厚生年金保険被保険者賞与等支払届チェックリスト) Imported from BI Publisher Description: 給与帳票(健康保険・厚生年金保険被保険者賞与等支払届チェックリスト) Application: Payroll Source: 給与帳票(健康保険・厚生年金保険被保険者賞与等支払届チェックリスト)(XML) Short Name: PAYJPBON_XML DB package: PAY_PAYJPBON_XMLP_PKG US PAY Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) Imported from BI Publisher Description: Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) Application: Payroll Source: Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) (XML) Short Name: PAYJPBON_XML DB package: PAY_PAYJPBON_XMLP_PKG BI Publisher &p_where_clause_for_assid :cp_birth_date_dd :cp_birth_date_era :cp_birth_date_erayymmdd :cp_birth_date_mm :cp_birth_date_yy :cp_bon_comp :cp_bon_comp_total :cp_bon_mtr_comp :cp_bon_payment_date :cp_bon_payment_date_dd :cp_bon_payment_date_mm :cp_bon_payment_date_yy :cp_bon_payment_date_yymmdd :cp_d_birth_date_era :cp_d_bon_comp_total :cp_emp_failure_item :cp_error_message :cp_exclude :cp_full_name :cp_hi_only :cp_payment_date_dd :cp_payment_date_mm :cp_payment_date_yy :cp_payment_date_yymmdd :cp_reported_date_dd :cp_reported_date_mm :cp_reported_date_yy :cp_reported_date_yymmdd :cp_scheduled_payment_mm :cp_scheduled_payment_yy :cp_scheduled_payment_yymm :cp_si_sex_code :cp_wp_only :g_bon_hi_std_prem_elm_id :g_bon_wp_std_prem_elm_id :g_earn_kind_sj_hi_prem_iv_id :g_earn_kind_sj_wp_prem_iv_id :g_earn_sj_hi_prem_iv_id :g_earn_sj_wp_prem_iv_id :g_eot :g_hi_disqualified_date_iv_id :g_hi_qualified_date_iv_id :g_rec_cnt :g_si_sex_iv_id :g_sot :g_wp_disqualified_date_iv_id :g_wp_qualified_date_iv_id :g_wpf_disqualified_date_iv_id :g_wpf_qualified_date_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_bon_hi_prem_iv_id :p_bon_hi_std_prem_ele_id :p_bon_wp_prem_iv_id :p_bon_wp_std_prem_ele_id :p_business_group_id :p_conc_request_id :p_organization_context :p_organization_id :p_output_flag :p_payment_date :p_payroll_action_id :p_reported_date :p_scheduled_payment_yyyymm :p_si_submit_type :p_sort_order :p_where_clause_for_assid 1 -40 :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 -30 :p_organization_context LOV Oracle PAY_JP_SRS_SI_ORG_INFORMATION_CONTEXT Y select hoit.org_information_type id, hoit.displayed_org_information_type value, null description from hr_org_information_types hoit,hr_organization_information hoi where hoi.organization_id=:$flex$.pay_jp_srs_si_organization_id and hoi.org_information_context in ('JP_HI_UNION_INFO','JP_WP_UNION_INFO','JP_WP_FUND_INFO') and hoit.org_information_type=hoi.org_information_context order by value,description select hoit.displayed_org_information_type from hr_org_information_types hoit where hoit.org_information_type=decode(:$flex$.submit_to,4,'JP_WP_FUND_INFO',decode(:$flex$.submit_to-trunc(:$flex$.submit_to/2)*2,1,'JP_HI_UNION_INFO','JP_WP_UNION_INFO')) Y JA 事業所所在地 事業所所在地 US Location Address Location Address 3 -20 :p_sort_order LOV Oracle PAY_JP_SRS_GEPPEN_SANTEI_SORT_ORDER Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='JP_SORT_ORDER' and lookup_code in ('HI_NUMBER','WP_NUMBER') order by lookup_code select decode(:$flex$.submit_to-trunc(:$flex$.submit_to/2)*2,1,hr_general.decode_lookup('JP_SORT_ORDER','HI_NUMBER') ,hr_general.decode_lookup('JP_SORT_ORDER','WP_NUMBER')) from dual Y JA ソート順 ソート順 US Sort Order Sort Order 4 10 :p_reported_date Date select fnd_date.date_to_chardate(effective_date) from fnd_sessions where session_id=userenv('sessionid') Y JA 提出日 提出日 US Reported Date Reported Date 5 20 :p_payment_date Date Y JA PAY_JP_SRS_SI_LOC_BON_EFFECTIVE_DATE 支払年月日 US PAY_JP_SRS_SI_LOC_BON_EFFECTIVE_DATE Payment Year/Month/Date 6 30 :p_payroll_action_id LOV Oracle PAY_JP_SRS_SI_BON_PAYROLL_ACTION_ID Y select payroll_action_id id, fnd_date.date_to_chardate(trunc(effective_date,'DD'))||'('||to_char(payroll_action_id)||')' value, hr_general.decode_lookup('YES_NO',pay_core_utils.get_parameter('SI_SUM_MTD_BON',legislative_parameters)) description from pay_jp_si_fd_action_date_v where business_group_id=:$flex$.pay_jp_srs_business_group_id and trunc(effective_date,'MM') =trunc(fnd_date.canonical_to_date(:$flex$.pay_jp_srs_si_loc_bon_effective_date),'MM') and element_set_code='BON' and default_value_flag='Y' and action_status='C' order by effective_date desc,hr_general.decode_payroll(payroll_id),pay_jp_report_pkg.decode_ass_set_name(assignment_set_id) select fnd_date.date_to_chardate(trunc(pjsfad.effective_date,'DD'))||'('||to_char(pjsfad.payroll_action_id)||')' from pay_jp_si_fd_action_date_v pjsfad where pjsfad.business_group_id = :$FLEX$.PAY_JP_SRS_BUSINESS_GROUP_ID and trunc(pjsfad.effective_date,'MM') = trunc(fnd_date.canonical_to_date(:$FLEX$.PAY_JP_SRS_SI_LOC_BON_EFFECTIVE_DATE),'MM') and pjsfad.element_set_code = 'BON' and pjsfad.default_value_flag = 'Y' and pjsfad.action_status = 'C' and not exists(select /*+ INDEX(PPA PAY_PAYROLL_ACTIONS_FK6) */ null from pay_payroll_actions ppa where ppa.business_group_id = pjsfad.business_group_id and ppa.element_set_id = pjsfad.element_set_id and ppa.action_status = 'C' and trunc(ppa.effective_date,'MM') = trunc(pjsfad.effective_date,'MM') and ppa.payroll_action_id > pjsfad.payroll_action_id) Y JA 賞与処理(最終) 賞与処理(最終) US Bonus Process (Latest) Bonus Process (Latest) 7 40 :p_scheduled_payment_yyyymm Char select to_char(ppa.effective_date,'YYYYMM') from pay_payroll_actions ppa where ppa.payroll_action_id = :$flex$.bonus_process_latest Y JA 支払予定年月 支払予定年月 US Scheduled Payment Year/Month Scheduled Payment Year/Month 8 50 :p_organization_id LOV Oracle PAY_JP_SRS_SI_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 in ('JP_KENKO','JP_KOUSEI','JP_KIKIN')) order by hou.name Y JA 事業所 事業所 US Location Location 9 60 :p_si_submit_type LOV Oracle PAY_JP_SRS_SI_SUBMIT_TYPE Y select to_number(hr.lookup_code) id, hr.meaning value, null description from hr_lookups hr where hr.lookup_type='JP_SI_TYPE' and hr.lookup_code in ( select min(hr2.lookup_code) from hr_lookups hr2, hr_organization_information hoi1, hr_organization_information hoi2, hr_organization_information hoi3 where hr2.lookup_type='JP_SI_TYPE' and hoi1.organization_id=:$flex$.pay_jp_srs_si_organization_id and hoi1.org_information_context in ('JP_HI_UNION_INFO','JP_WP_UNION_INFO','JP_WP_FUND_INFO') and hoi2.organization_id=hoi1.organization_id and hoi2.org_information_context in ('JP_HI_UNION_INFO','JP_WP_UNION_INFO','JP_WP_FUND_INFO') and hoi3.organization_id=hoi1.organization_id and hoi3.org_information_context in ('JP_HI_UNION_INFO','JP_WP_UNION_INFO','JP_WP_FUND_INFO') and ( (hr2.lookup_code='1' and hoi1.org_information_context='JP_HI_UNION_INFO') or (hr2.lookup_code='2' and hoi2.org_information_context='JP_WP_UNION_INFO') or (hr2.lookup_code='3' and hoi1.org_information_context='JP_HI_UNION_INFO' and hoi2.org_information_context='JP_WP_UNION_INFO') or (hr2.lookup_code='4' and hoi3.org_information_context='JP_WP_FUND_INFO') or (hr2.lookup_code='5' and hoi1.org_information_context='JP_HI_UNION_INFO' and hoi3.org_information_context='JP_WP_FUND_INFO') or (hr2.lookup_code='6' and hoi2.org_information_context='JP_WP_UNION_INFO' and hoi3.org_information_context='JP_WP_FUND_INFO') or (hr2.lookup_code='7' and hoi1.org_information_context='JP_HI_UNION_INFO' and hoi2.org_information_context='JP_WP_UNION_INFO' and hoi3.org_information_context='JP_WP_FUND_INFO')) group by hr2.lookup_code ) order by hr.lookup_code Y JA 提出先 提出先 US Submit to Submit to 10 70 :p_output_flag LOV Oracle PAY_JP_SRS_SI_REPORT_OUTPUT_FLAG Y select lookup_code id, meaning value, description description from hr_lookups where lookup_type='JP_SI_REPORT_OUTPUT' order by lookup_code SELECT meaning FROM hr_lookups WHERE lookup_type = 'JP_SI_REPORT_OUTPUT' AND lookup_code = '0' Y JA 出力対象区分 出力対象区分 US Output Flag Output Flag 11 80 :p_assignment_id1 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員1 従業員1 US Employee1 Employee1 12 90 :p_assignment_id2 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員2 従業員2 US Employee2 Employee2 13 100 :p_assignment_id3 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員3 従業員3 US Employee3 Employee3 14 110 :p_assignment_id4 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員4 従業員4 US Employee4 Employee4 15 120 :p_assignment_id5 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員5 従業員5 US Employee5 Employee5 16 130 :p_assignment_id6 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員6 従業員6 US Employee6 Employee6 17 140 :p_assignment_id7 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員7 従業員7 US Employee7 Employee7 18 150 :p_assignment_id8 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員8 従業員8 US Employee8 Employee8 19 160 :p_assignment_id9 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員9 従業員9 US Employee9 Employee9 20 170 :p_assignment_id10 LOV Oracle PAY_JP_SRS_SI_BON_ASSID Y select paa2.assignment_id id, pp.employee_number value, substr(rpad(pp.last_name||' '||pp.first_name,15,' '),1,50) description from pay_payroll_actions ppa,pay_payroll_actions ppa2,pay_assignment_actions paa2,per_all_assignments_f pa,per_all_people_f pp where ppa.payroll_action_id=:$flex$.pay_jp_srs_si_bon_payroll_action_id and ppa.business_group_id=:$flex$.pay_jp_srs_business_group_id and ppa2.business_group_id=ppa.business_group_id and ppa2.action_type='R' and ppa2.element_set_id=ppa.element_set_id and ((pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='N' and ppa2.payroll_action_id=ppa.payroll_action_id) or (pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters)='Y' and ppa2.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa2.legislative_parameters)='Y')) and paa2.payroll_action_id=ppa2.payroll_action_id and paa2.action_status='C' and not exists( select null from pay_payroll_actions ppa3, pay_assignment_actions paa3 where ppa3.element_set_id=ppa.element_set_id and ppa3.effective_date between trunc(ppa.effective_date,'MM') and ppa.effective_date and ppa3.business_group_id=ppa.business_group_id and ppa3.action_type='R' and paa3.payroll_action_id=ppa3.payroll_action_id and paa3.action_status='C' and paa3.assignment_id=paa2.assignment_id and pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa3.legislative_parameters)=pay_core_utils.get_parameter('SI_SUM_MTD_BON',ppa.legislative_parameters) and paa3.action_sequence>paa2.action_sequence) and pa.assignment_id=paa2.assignment_id and ppa2.effective_date between pa.effective_start_date and pa.effective_end_date and pp.person_id=pa.person_id and ppa2.effective_date between pp.effective_start_date and pp.effective_end_date order by lpad(pp.employee_number,30,' ') JA 従業員10 従業員10 US Employee10 Employee10