DBA Data[Home] [Help]

APPS.PAY_JP_ITWB_REPORT_PKG dependencies on HR_GENERAL

Line 2616: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sex := hr_general.decode_lookup('SEX',l_csr_data_ass.sex);

2612: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_last_name_kana := l_csr_data_ass.last_name_kana;
2613: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_first_name_kana := l_csr_data_ass.first_name_kana;
2614: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_full_name_kana := l_csr_data_ass.last_name_kana||' '||l_csr_data_ass.first_name_kana;
2615: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_sex_b := l_csr_data_ass.sex;
2616: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sex := hr_general.decode_lookup('SEX',l_csr_data_ass.sex);
2617: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_birth_date := l_csr_data_ass.birth_date;
2618: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_birth_date_d := pay_jp_report_pkg.jp_era_date(l_csr_data_ass.birth_date,'EYY.MM.DD');
2619: --
2620: l_temp_date := l_csr_data_ass.proc_effective_date;

Line 2649: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_itax_type := hr_general.decode_lookup('JP_ITAX_TYPE',l_csr_data_ass.itax_type);

2645: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_job_name := l_csr_data_ass.job_name;
2646: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_payroll_name := l_csr_data_ass.payroll_name;
2647: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_location_name := l_csr_data_ass.location_name;
2648: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_itax_type_b := l_csr_data_ass.itax_type;
2649: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_itax_type := hr_general.decode_lookup('JP_ITAX_TYPE',l_csr_data_ass.itax_type);
2650: --
2651: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_itax_type_d := g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_itax_type;
2652: if nvl(l_csr_data_ass.non_res_flag,'N') = 'Y' then
2653: --

Line 2665: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_declare_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.declare_flag);

2661: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_ei_number := l_csr_data_ass.ei_number;
2662: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_non_res_flag := l_csr_data_ass.non_res_flag;
2663: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_itax_type := l_csr_data_ass.dep_itax_type;
2664: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_declare_flag_b := l_csr_data_ass.declare_flag;
2665: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_declare_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.declare_flag);
2666: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_type := l_csr_data_ass.spouse_type;
2667: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_flag_b := l_csr_data_ass.spouse_flag;
2668: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.spouse_flag);
2669: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_spouse_b := l_csr_data_ass.dep_spouse;

Line 2668: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.spouse_flag);

2664: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_declare_flag_b := l_csr_data_ass.declare_flag;
2665: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_declare_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.declare_flag);
2666: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_type := l_csr_data_ass.spouse_type;
2667: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_flag_b := l_csr_data_ass.spouse_flag;
2668: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.spouse_flag);
2669: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_spouse_b := l_csr_data_ass.dep_spouse;
2670: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.dep_spouse);
2671: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_aged_dep_spouse_b := l_csr_data_ass.aged_dep_spouse;
2672: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.aged_dep_spouse);

Line 2670: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.dep_spouse);

2666: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_type := l_csr_data_ass.spouse_type;
2667: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_spouse_flag_b := l_csr_data_ass.spouse_flag;
2668: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.spouse_flag);
2669: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_spouse_b := l_csr_data_ass.dep_spouse;
2670: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.dep_spouse);
2671: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_aged_dep_spouse_b := l_csr_data_ass.aged_dep_spouse;
2672: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.aged_dep_spouse);
2673: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_ord_dep_num := l_csr_data_ass.ord_dep_num;
2674: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sp_dep_num := l_csr_data_ass.sp_dep_num;

Line 2672: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.aged_dep_spouse);

2668: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_spouse_flag := hr_general.decode_lookup('YES_NO',l_csr_data_ass.spouse_flag);
2669: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_spouse_b := l_csr_data_ass.dep_spouse;
2670: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.dep_spouse);
2671: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_aged_dep_spouse_b := l_csr_data_ass.aged_dep_spouse;
2672: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_dep_spouse := hr_general.decode_lookup('YES_NO',l_csr_data_ass.aged_dep_spouse);
2673: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_ord_dep_num := l_csr_data_ass.ord_dep_num;
2674: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sp_dep_num := l_csr_data_ass.sp_dep_num;
2675: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_parent_dep_lt_num := l_csr_data_ass.aged_parent_dep_lt_num;
2676: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_aged_dep_num := l_csr_data_ass.aged_dep_num;

Line 2681: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_disable_type := hr_general.decode_lookup('JP_DISABLED_EE_STATUS',l_csr_data_ass.disable_type);

2677: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_ord_disable_num := l_csr_data_ass.ord_disable_num;
2678: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sp_disable_num := l_csr_data_ass.sp_disable_num;
2679: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sp_disable_lt_num := l_csr_data_ass.sp_disable_lt_num;
2680: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_disable_type_b := l_csr_data_ass.disable_type;
2681: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_disable_type := hr_general.decode_lookup('JP_DISABLED_EE_STATUS',l_csr_data_ass.disable_type);
2682: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_widow_type_b := l_csr_data_ass.widow_type;
2683: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_widow_type := hr_general.decode_lookup('JP_WIDOW_EE_STATUS',l_csr_data_ass.widow_type);
2684: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_working_student_type_b := l_csr_data_ass.working_student_type;
2685: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_working_student_type := hr_general.decode_lookup('JP_WORKING_STUDENT_EE_STATUS',l_csr_data_ass.working_student_type);

Line 2683: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_widow_type := hr_general.decode_lookup('JP_WIDOW_EE_STATUS',l_csr_data_ass.widow_type);

2679: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_sp_disable_lt_num := l_csr_data_ass.sp_disable_lt_num;
2680: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_disable_type_b := l_csr_data_ass.disable_type;
2681: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_disable_type := hr_general.decode_lookup('JP_DISABLED_EE_STATUS',l_csr_data_ass.disable_type);
2682: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_widow_type_b := l_csr_data_ass.widow_type;
2683: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_widow_type := hr_general.decode_lookup('JP_WIDOW_EE_STATUS',l_csr_data_ass.widow_type);
2684: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_working_student_type_b := l_csr_data_ass.working_student_type;
2685: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_working_student_type := hr_general.decode_lookup('JP_WORKING_STUDENT_EE_STATUS',l_csr_data_ass.working_student_type);
2686: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_otsu_spouse_dep_num := l_csr_data_ass.otsu_spouse_dep_num;
2687: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_non_res_flag := l_csr_data_ass.dep_non_res_flag;

Line 2685: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_working_student_type := hr_general.decode_lookup('JP_WORKING_STUDENT_EE_STATUS',l_csr_data_ass.working_student_type);

2681: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_disable_type := hr_general.decode_lookup('JP_DISABLED_EE_STATUS',l_csr_data_ass.disable_type);
2682: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_widow_type_b := l_csr_data_ass.widow_type;
2683: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_widow_type := hr_general.decode_lookup('JP_WIDOW_EE_STATUS',l_csr_data_ass.widow_type);
2684: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_working_student_type_b := l_csr_data_ass.working_student_type;
2685: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_working_student_type := hr_general.decode_lookup('JP_WORKING_STUDENT_EE_STATUS',l_csr_data_ass.working_student_type);
2686: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).o_otsu_spouse_dep_num := l_csr_data_ass.otsu_spouse_dep_num;
2687: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_dep_non_res_flag := l_csr_data_ass.dep_non_res_flag;
2688: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_yea_efd := l_csr_data_ass.yea_efd;
2689: g_body_tbl(g_assact_tbl(l_assact_tbl_cnt)).a_yea_erd := l_csr_data_ass.yea_erd;