[Home] [Help]
90: c_small_comp_mut_aid_prem_iv constant varchar2(80) := 'SMALL_COMPANY_MUTUAL_AID_PREM';
91: c_dec_sc_mut_aid_prem_iv constant varchar2(80) := 'DECLARE_SMALL_COMPANY_MUTUAL_AID_PREM';
92: c_life_ins_prem_exm_iv constant varchar2(80) := 'LIFE_INS_PREM_EXM';
93: --c_gen_life_ins_prem_iv constant varchar2(80) := 'GEN_LIFE_INS_PREM';
94: c_individual_pension_prem_iv constant varchar2(80) := 'INDIVIDUAL_PENSION_PREM';
95: --c_nonlife_ins_prem_exm_iv constant varchar2(80) := 'NONLIFE_INS_PREM_EXM';
96: c_lt_nonlife_ins_prem_iv constant varchar2(80) := 'LONG_TERM_NONLIFE_INS_PREM';
97: c_earthquake_ins_prem_exm_iv constant varchar2(80) := 'NONLIFE_INS_PREM_EXM';
98: c_spouse_sp_exm_iv constant varchar2(80) := 'SPOUSE_SP_EXM';
299: c_dec_si_prem_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_dec_si_prem_iv);
300: c_sc_mut_aid_prem_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_small_comp_mut_aid_prem_iv);
301: c_dec_sc_mut_aid_prem_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_dec_sc_mut_aid_prem_iv);
302: c_life_ins_prem_exm_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_life_ins_prem_exm_iv);
303: c_ind_pension_prem_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_individual_pension_prem_iv);
304: c_lt_nonlife_ins_prem_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_lt_nonlife_ins_prem_iv);
305: c_spouse_income_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_spouse_income_iv);
306: c_eq_ins_prem_exm_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_earthquake_ins_prem_exm_iv);
307: c_spouse_sp_exm_iv_id constant number := hr_jp_id_pkg.input_value_id(c_yea_ins_sp_exm_rslt_elm_id,c_spouse_sp_exm_iv);
1746: --
1747: cursor csr_arch_pact_exist
1748: is
1749: select 'Y'
1750: from dual
1751: where not exists(
1752: select null
1753: from hr_organization_information hoi,
1754: hr_all_organization_units hou
7195: end if;
7196: --
7197: select pay_assignment_actions_s.nextval
7198: into l_assignment_action_id
7199: from dual;
7200: --
7201: if g_debug
7202: and g_detail_debug = 'Y' then
7203: l_assact_step := 29;
14599: p_sp_widow_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sp_widow_exm,
14600: p_working_student_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_working_student_exm,
14601: p_dep_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_dep_exm_calc,
14602: p_spouse_income => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_spouse_income,
14603: p_individual_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_ind_pension_prem,
14604: p_long_term_nonlife_ins_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_lt_nonlife_ins_prem,
14605: p_small_comp_mut_aid_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sc_mut_prem_calc,
14606: p_national_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_national_pension_prem,
14607: p_income_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_income_exm,
16945: p_sp_widow_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sp_widow_exm,
16946: p_working_student_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_working_student_exm,
16947: p_dep_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_dep_exm_calc,
16948: p_spouse_income => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_spouse_income,
16949: p_individual_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_ind_pension_prem,
16950: p_long_term_nonlife_ins_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_lt_nonlife_ins_prem,
16951: p_small_comp_mut_aid_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sc_mut_prem_calc,
16952: p_national_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_national_pension_prem,
16953: p_income_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_income_exm,
19395: p_sp_widow_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sp_widow_exm,
19396: p_working_student_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_working_student_exm,
19397: p_dep_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_dep_exm_calc,
19398: p_spouse_income => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_spouse_income,
19399: p_individual_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_ind_pension_prem,
19400: p_long_term_nonlife_ins_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_lt_nonlife_ins_prem,
19401: p_small_comp_mut_aid_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_sc_mut_prem_calc,
19402: p_national_pension_prem => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_national_pension_prem,
19403: p_income_exm => g_data_yea_tbl(nvl(g_body_tbl(p_assignment_action_id).yea_act,0)).yea_dct_income_exm,