ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713E51A9E05362FB09050512Y select /*+ leading(PAY_JP_LABOR_INS_V.ppa) use_nl(PAY_JP_LABOR_INS_V.ppa PAY_JP_LABOR_INS_V.paa) */ salary_category, target_month, count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EE',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)) WAI_EE_COUNT, nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EE',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0) WAI_EE_SAL_AMT, count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EX',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)) WAI_EX_COUNT, nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EX',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0) WAI_EX_SAL_AMT, count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'TW',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)) WAI_TW_COUNT, nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'TW',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0) WAI_TW_SAL_AMT, count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE',decode(sign(ui_sal_amt),1,'X',NULL),'EE_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL)) UI_EE_COUNT, nvl(sum(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),'EE_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),NULL),NULL)),0) UI_EE_SAL_AMT, count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EX',decode(sign(ui_sal_amt),1,'X',NULL),'EX_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL)) UI_EX_COUNT, nvl(sum(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EX',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),'EX_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),NULL),NULL)),0) UI_EX_SAL_AMT, count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE_AGED',decode(sign(ui_sal_amt),1,'X',NULL),'EX_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL)) UI_AGED_COUNT, nvl(sum(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),'EX_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),NULL),NULL)),0) UI_AGED_SAL_AMT, PAY_PAYJPFLI_XMLP_PKG.cf_li_dummyformula(salary_category,target_month,count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EE',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)),count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EX',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)),count(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'TW',decode(sign(wai_sal_amt),1,'X',NULL),NULL),NULL)),nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EE',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0),nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'EX',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0),nvl(sum(decode(wai_organization_id,:P_ORGANIZATION_ID,decode(wai_category,'TW',decode(sign(wai_sal_amt),1,wai_sal_amt,NULL),NULL),NULL)),0),count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE',decode(sign(ui_sal_amt),1,'X',NULL),'EE_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL)),count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EX',decode(sign(ui_sal_amt),1,'X',NULL),'EX_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL)),nvl(sum(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),'EE_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),NULL),NULL)),0),nvl(sum(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EX',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),'EX_AGED',decode(sign(ui_sal_amt),1,ui_sal_amt,NULL),NULL),NULL)),0),count(decode(ui_organization_id,:P_ORGANIZATION_ID,decode(ui_category,'EE_AGED',decode(sign(ui_sal_amt),1,'X',NULL),'EX_AGED',decode(sign(ui_sal_amt),1,'X',NULL),NULL),NULL))), PAY_PAYJPFLI_XMLP_PKG.CP_SALARY_CATEGORY_p CP_SALARY_CATEGORY, PAY_PAYJPFLI_XMLP_PKG.CP_TARGET_YEAR_p CP_TARGET_YEAR, PAY_PAYJPFLI_XMLP_PKG.CP_TARGET_MONTH_p CP_TARGET_MONTH, PAY_PAYJPFLI_XMLP_PKG.CP_WAI_COUNT_p CP_WAI_COUNT, PAY_PAYJPFLI_XMLP_PKG.CP_WAI_SAL_AMT_p CP_WAI_SAL_AMT, PAY_PAYJPFLI_XMLP_PKG.CP_UI_AGED_SAL_AMT_SUM_p CP_UI_AGED_SAL_AMT_SUM, PAY_PAYJPFLI_XMLP_PKG.CP_UI_COUNT_p CP_UI_COUNT, PAY_PAYJPFLI_XMLP_PKG.CP_UI_SAL_AMT_p CP_UI_SAL_AMT, 'X' dummy from PAY_JP_LABOR_INS_V where business_group_id=:P_BUSINESS_GROUP_ID and to_number(target_month) between to_number(to_char(:P_FISCAL_YEAR) || '04') and to_number(to_char(:P_FISCAL_YEAR + 1) || '03') and (wai_organization_id=:P_ORGANIZATION_ID or ui_organization_id=:P_ORGANIZATION_ID) and (wai_sal_amt > 0 or ui_sal_amt > 0) group by salary_category, target_month order by decode(salary_category,'SALARY',1,'BONUS',2,'SP_BONUS',3),2 PAY PAYJPFLI_XML JA PAY 給与帳票(確定保険料算定基礎賃金集計表) Imported from BI Publisher Description: 給与帳票(確定保険料算定基礎賃金集計表) Application: Payroll Source: 給与帳票(確定保険料算定基礎賃金集計表)(XML) Short Name: PAYJPFLI_XML DB package: PAY_PAYJPFLI_XMLP_PKG US PAY Payroll Report (Final Notice of Fixed Labor Ins Fee) Imported from BI Publisher Description: Payroll Report (Final Notice of Fixed Labor Ins Fee) Application: Payroll Source: Payroll Report (Final Notice of Fixed Labor Ins Fee) (XML) Short Name: PAYJPFLI_XML DB package: PAY_PAYJPFLI_XMLP_PKG BI Publisher :cp_num_of_salary_months :cp_report_title :cp_salary_category :cp_target_month :cp_target_year :cp_ui_aged_count_salary_avg :cp_ui_aged_count_salary_sum :cp_ui_aged_sal_amt_sum :cp_ui_count :cp_ui_count_salary_avg :cp_ui_count_salary_sum :cp_ui_net_sal_amt_sum :cp_ui_sal_amt :cp_ui_sal_amt_sum :cp_wai_count :cp_wai_count_salary_avg :cp_wai_count_salary_sum :cp_wai_sal_amt :cp_wai_sal_amt_sum :p_business_group_id :p_conc_request_id :p_fiscal_year :p_organization_id 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 ビジネス・グループ ビジネス・グループ US Business Group Business Group 2 10 :p_fiscal_year Number select to_number(to_char(add_months(effective_date,-12),'YYYY')) from fnd_sessions where session_id=userenv('sessionid') Y JA 年度 年度 US Fiscal Year Fiscal Year 3 20 :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