[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select parameter_value
from pay_action_parameters
where parameter_name = 'JP_DEBUG_PAYJPITWB';
select piv.uom
from pay_input_values_f piv
where piv.input_value_id = p_item_id
and nvl(piv.business_group_id,g_business_group_id) = g_business_group_id
and nvl(piv.legislation_code,g_legislation_code) = g_legislation_code;
select /*+ ORDERED */
pbt.balance_uom
from pay_defined_balances pdb,
pay_balance_types pbt
where pdb.defined_balance_id = p_item_id
and nvl(pdb.business_group_id,g_business_group_id) = g_business_group_id
and nvl(pdb.legislation_code,g_legislation_code) = g_legislation_code
and pbt.balance_type_id = pdb.balance_type_id
and nvl(pbt.business_group_id,g_business_group_id) = g_business_group_id
and nvl(pbt.legislation_code,g_legislation_code) = g_legislation_code;
select /*+ ORDERED */
ppa.business_group_id,
ppa.effective_date,
ppa.legislative_parameters,
pbg.legislation_code
from pay_payroll_actions ppa,
per_business_groups_perf pbg
where ppa.payroll_action_id = p_payroll_action_id
and pbg.business_group_id = ppa.business_group_id;
'select distinct ppos.person_id
from pay_payroll_actions ppa,
per_all_people_f pp,
per_periods_of_service ppos
where ppa.payroll_action_id = :payroll_action_id
and pp.business_group_id = ppa.business_group_id + 0
and ppos.person_id = pp.person_id
and ppos.business_group_id + 0 = pp.business_group_id
and ppos.date_start <= fnd_date.canonical_to_date(''i_effective_eoy'')
and nvl(ppos.final_process_date,fnd_date.canonical_to_date(''i_effective_soy'')) >= fnd_date.canonical_to_date(''i_effective_soy'')
order by
ppos.person_id';
select /*+ ORDERED */
pjie.person_id,
pjia.assignment_id,
pjia.assignment_action_id,
ppa.effective_date
from pay_jp_itwb_assact_latest_v pjia,
pay_jp_itwb_emp_v pjie,
pay_jp_itwb_emp_si_v pjies,
pay_assignment_actions paa,
pay_payroll_actions ppa
--where ppos.person_id
-- between p_start_person_id and p_end_person_id
where pjia.effective_date
between g_effective_soy and g_effective_eoy
and pjie.assignment_action_id = pjia.assignment_action_id
and pjie.effective_date = pjia.effective_date
and pjies.assignment_action_id = pjia.assignment_action_id
and pjies.effective_date = pjia.effective_date
and pjies.itax_org_id = g_itax_organization_id
and pjia.payroll_id = nvl(g_payroll_id,pjia.payroll_id)
and nvl(pjia.location_id,-1) = nvl(g_location_id,nvl(pjia.location_id,-1))
and (g_organization_id is null
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'Y'
and pjia.organization_id in (
select /*+ ORDERED */
distinct pose.organization_id_child
from per_organization_structures pos,
per_org_structure_versions posv,
per_org_structure_elements pose
where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
and pos.primary_structure_flag = 'Y'
and posv.organization_structure_id = pos.organization_structure_id
and posv.date_from <= g_effective_eoy
and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
and not exists(
select null
from per_org_structure_versions posv2
where posv2.organization_structure_id = pos.organization_structure_id
and posv2.date_from <= g_effective_eoy
and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
and posv2.version_number > posv.version_number)
and pose.org_structure_version_id = posv.org_structure_version_id
start with pose.organization_id_parent = g_organization_id
connect by prior pose.organization_id_child = pose.organization_id_parent
union
select hou.organization_id
from hr_all_organization_units hou
where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
and hou.organization_id <> hou.business_group_id
union
select g_organization_id
from dual))
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'N'
and pjia.organization_id = g_organization_id))
and ((g_inc_term_flag = 'N'
and least(nvl(pjia.termination_date,g_effective_eoy + 1),g_effective_eoy + 1) > g_effective_eoy)
or (g_inc_term_flag = 'Y'
and ((g_term_date_from is null
and g_term_date_to is null)
or (pjia.termination_date
between nvl(g_term_date_from,pjia.termination_date) and nvl(g_term_date_to,pjia.termination_date)))))
and paa.assignment_action_id = pjia.proc_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
order by pjie.person_id;
select /*+ ORDERED */
pjie.person_id,
pjia.assignment_id,
pjia.assignment_action_id,
ppa.effective_date,
hasa.include_or_exclude
from pay_jp_itwb_assact_latest_v pjia,
pay_jp_itwb_emp_v pjie,
pay_jp_itwb_emp_si_v pjies,
hr_assignment_set_amendments hasa,
pay_assignment_actions paa,
pay_payroll_actions ppa
--where ppos.person_id
-- between p_start_person_id and p_end_person_id
where pjia.effective_date
between g_effective_soy and g_effective_eoy
and pjie.assignment_action_id = pjia.assignment_action_id
and pjie.effective_date = pjia.effective_date
and pjies.assignment_action_id = pjia.assignment_action_id
and pjies.effective_date = pjia.effective_date
and pjies.itax_org_id = g_itax_organization_id
and pjia.payroll_id = nvl(g_payroll_id,pjia.payroll_id)
and nvl(pjia.location_id,-1) = nvl(g_location_id,nvl(pjia.location_id,-1))
and (g_organization_id is null
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'Y'
and pjia.organization_id in (
select /*+ ORDERED */
distinct pose.organization_id_child
from per_organization_structures pos,
per_org_structure_versions posv,
per_org_structure_elements pose
where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
and pos.primary_structure_flag = 'Y'
and posv.organization_structure_id = pos.organization_structure_id
and posv.date_from <= g_effective_eoy
and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
and not exists(
select null
from per_org_structure_versions posv2
where posv2.organization_structure_id = pos.organization_structure_id
and posv2.date_from <= g_effective_eoy
and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
and posv2.version_number > posv.version_number)
and pose.org_structure_version_id = posv.org_structure_version_id
start with pose.organization_id_parent = g_organization_id
connect by prior pose.organization_id_child = pose.organization_id_parent
union
select hou.organization_id
from hr_all_organization_units hou
where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
and hou.organization_id <> hou.business_group_id
union
select g_organization_id
from dual))
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'N'
and pjia.organization_id = g_organization_id))
and ((g_inc_term_flag = 'N'
and least(nvl(pjia.termination_date,g_effective_eoy + 1),g_effective_eoy + 1) > g_effective_eoy)
or (g_inc_term_flag = 'Y'
and ((g_term_date_from is null
and g_term_date_to is null)
or (pjia.termination_date
between nvl(g_term_date_from,pjia.termination_date) and nvl(g_term_date_to,pjia.termination_date)))))
and to_number(decode(nvl(to_char(g_ass_set_formula_id),'-1'),'-1',
decode(nvl(g_ass_set_amendment_type,'X'),'I',hasa.assignment_id,pjia.assignment_id),
pjia.assignment_id)) = pjia.assignment_id
and hasa.assignment_set_id (+) = g_assignment_set_id
and hasa.assignment_id (+) = pjia.assignment_id
and nvl(hasa.include_or_exclude,'I') <> 'E'
and paa.assignment_action_id = pjia.proc_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
order by pjie.person_id;
g_per_ind_tbl.delete;
g_ass_ind_tbl.delete;
g_ass_tbl.delete;
l_ass_id_tbl.delete;
select pay_assignment_actions_s.nextval
into l_assignment_action_id
from dual;
select /*+ ORDERED */
mpaa.assignment_action_id mag_assignment_action_id,
pjia.assignment_action_id arch_assignment_action_id,
pjia.effective_date arch_effective_date,
pjiio.name itax_org_name,
pjiio.name_kana itax_org_name_kana,
pjiio.address1||pjiio.address2 itax_org_address,
pjiio.address_kana1||pjiio.address_kana2 itax_org_address_kana,
pjiio.phone itax_org_phone,
pjiio.serial1 itax_org_serial1,
pjiio.serial2 itax_org_serial2,
pjie.employee_number,
pjie.last_name,
pjie.first_name,
pjie.last_name_kana,
pjie.first_name_kana,
pjie.sex,
pjie.birth_date,
proc_ppa.effective_date proc_effective_date,
pjiead.address_jp,
pjiead.postal_code,
pjiead.district_code,
pjiead.address1||pjiead.address2 address,
pjiead.address_kana1||pjiead.address_kana2 address_kana,
pjiead.phone1,
pjiead.phone2,
pjieas.hire_date,
pjia.termination_date,
pjia.leaving_reason,
pjieas.organization_name,
pjieas.job_name,
pjieas.payroll_name,
pjieas.location_name,
pjies.itax_type,
pjies.hi_number,
pjies.wp_number,
pjies.wpf_number,
pjies.ei_number,
pjies.nres_flag non_res_flag,
pjid.dep_itax_type,
pjid.declare_flag,
pjid.spouse_type,
pjid.spouse_flag,
pjid.dep_spouse,
pjid.aged_dep_spouse,
pjid.ord_dep_num,
pjid.sp_dep_num,
pjid.aged_parent_dep_lt_num,
pjid.aged_dep_num,
pjid.ord_disable_num,
pjid.sp_disable_num,
pjid.sp_disable_lt_num,
pjid.disable_type,
pjid.widow_type,
pjid.working_student_type,
pjid.otsu_spouse_dep_num,
pjid.non_res_flag dep_non_res_flag,
pjiya.efd yea_efd,
pjiya.erd yea_erd,
pjiya.yea_type,
pjiya.yea_flag,
pjiyp.sal_txbl_mon,
pjiyp.sal_txbl_kind,
pjiyp.sal_txbl,
pjiyp.bon_txbl_mon,
pjiyp.bon_txbl_kind,
pjiyp.bon_txbl,
pjiyp.spb_txbl_mon,
pjiyp.spb_txbl_kind,
pjiyp.spb_txbl,
pjiyp.bon_txbl_tot,
pjiyp.yea_txbl,
pjiyp.sal_itx,
pjiyp.bon_itx,
pjiyp.spb_itx,
pjiyp.bon_itx_tot,
pjiyp.withhold_itx,
pjiyd.sal_dct_si_prem,
pjiyd.dec_si_prem,
pjiyd.dec_small_comp_mut_aid_prem,
pjiyd.life_ins_prem_exm,
pjiyd.earthquake_ins_prem_exm,
pjiyd.spouse_sp_exm,
pjiyd.basic_exm,
pjiyd.gen_spouse_exm,
pjiyd.elder_spouse_exm,
pjiyd.gen_dep_exm,
pjiyd.specific_dep_exm,
pjiyd.junior_dep_exm,
pjiyd.elder_dep_exm,
pjiyd.elder_parent_lt_exm,
pjiyd.gen_disabled_exm,
pjiyd.sev_disabled_exm,
pjiyd.sev_disabled_lt_exm,
pjiyd.elder_exm,
pjiyd.widow_exm,
pjiyd.sp_widow_exm,
pjiyd.working_student_exm,
pjiyd.dep_exm,
pjiyd.spouse_income,
pjiyd.individual_pension_prem,
pjiyd.long_term_nonlife_ins_prem,
pjiyd.small_comp_mut_aid_prem,
pjiyd.national_pension_prem,
pjiyd.income_exm,
pjiyt.amt_aft_emp_inc_dct,
pjiyt.net_txbl_income,
pjiyt.annual_tax,
pjiyt.actual_housing_loan_tax_credit,
pjiyt.yea_annual_tax,
pjiyt.yea_income_tax,
pjiyt.yea_tax_pay,
pjisaef.col_mth1 sal_efd_mth1,
pjisaef.col_mth2 sal_efd_mth2,
pjisaef.col_mth3 sal_efd_mth3,
pjisaef.col_mth4 sal_efd_mth4,
pjisaef.col_mth5 sal_efd_mth5,
pjisaef.col_mth6 sal_efd_mth6,
pjisaef.col_mth7 sal_efd_mth7,
pjisaef.col_mth8 sal_efd_mth8,
pjisaef.col_mth9 sal_efd_mth9,
pjisaef.col_mth10 sal_efd_mth10,
pjisaef.col_mth11 sal_efd_mth11,
pjisaef.col_mth12 sal_efd_mth12,
pjibaef.col_cnt1 bon_efd_cnt1,
pjibaef.col_cnt2 bon_efd_cnt2,
pjibaef.col_cnt3 bon_efd_cnt3,
pjibaef.col_cnt4 bon_efd_cnt4,
pjibaef.col_cnt5 bon_efd_cnt5,
pjibaef.col_cnt6 bon_efd_cnt6,
pjibaef.col_cnt7 bon_efd_cnt7,
pjibaef.col_cnt8 bon_efd_cnt8,
pjibaef.col_cnt9 bon_efd_cnt9,
pjibaef.col_cnt10 bon_efd_cnt10,
pjibaef.col_cnt11 bon_efd_cnt11,
pjibaef.col_cnt12 bon_efd_cnt12,
pjibaef.col_cnt13 bon_efd_cnt13,
pjibaef.col_cnt14 bon_efd_cnt14,
pjibaer.col_cnt15 bon_efd_cnt15,
pjisaer.col_mth1 sal_erd_mth1,
pjisaer.col_mth2 sal_erd_mth2,
pjisaer.col_mth3 sal_erd_mth3,
pjisaer.col_mth4 sal_erd_mth4,
pjisaer.col_mth5 sal_erd_mth5,
pjisaer.col_mth6 sal_erd_mth6,
pjisaer.col_mth7 sal_erd_mth7,
pjisaer.col_mth8 sal_erd_mth8,
pjisaer.col_mth9 sal_erd_mth9,
pjisaer.col_mth10 sal_erd_mth10,
pjisaer.col_mth11 sal_erd_mth11,
pjisaer.col_mth12 sal_erd_mth12,
pjibaer.col_cnt1 bon_erd_cnt1,
pjibaer.col_cnt2 bon_erd_cnt2,
pjibaer.col_cnt3 bon_erd_cnt3,
pjibaer.col_cnt4 bon_erd_cnt4,
pjibaer.col_cnt5 bon_erd_cnt5,
pjibaer.col_cnt6 bon_erd_cnt6,
pjibaer.col_cnt7 bon_erd_cnt7,
pjibaer.col_cnt8 bon_erd_cnt8,
pjibaer.col_cnt9 bon_erd_cnt9,
pjibaer.col_cnt10 bon_erd_cnt10,
pjibaer.col_cnt11 bon_erd_cnt11,
pjibaer.col_cnt12 bon_erd_cnt12,
pjibaer.col_cnt13 bon_erd_cnt13,
pjibaer.col_cnt14 bon_erd_cnt14,
pjibaer.col_cnt15 bon_erd_cnt15,
pjibat.col_cnt1 bon_type_cnt1,
pjibat.col_cnt2 bon_type_cnt2,
pjibat.col_cnt3 bon_type_cnt3,
pjibat.col_cnt4 bon_type_cnt4,
pjibat.col_cnt5 bon_type_cnt5,
pjibat.col_cnt6 bon_type_cnt6,
pjibat.col_cnt7 bon_type_cnt7,
pjibat.col_cnt8 bon_type_cnt8,
pjibat.col_cnt9 bon_type_cnt9,
pjibat.col_cnt10 bon_type_cnt10,
pjibat.col_cnt11 bon_type_cnt11,
pjibat.col_cnt12 bon_type_cnt12,
pjibat.col_cnt13 bon_type_cnt13,
pjibat.col_cnt14 bon_type_cnt14,
pjibat.col_cnt15 bon_type_cnt15
from pay_assignment_actions mpaa,
pay_jp_itwb_assact_latest_v pjia,
pay_jp_itwb_emp_v pjie,
pay_jp_itwb_emp_si_v pjies,
pay_assignment_actions arch_paa,
pay_jp_itwb_itax_org_v pjiio,
pay_jp_itwb_emp_add_v pjiead,
pay_jp_itwb_emp_ass_v pjieas,
pay_jp_itwb_dep_v pjid,
pay_jp_itwb_yea_act_v pjiya,
pay_jp_itwb_yea_pay_v pjiyp,
pay_jp_itwb_yea_dct_v pjiyd,
pay_jp_itwb_yea_tax_v pjiyt,
pay_jp_itwb_sal_act_efd_v pjisaef,
pay_jp_itwb_bon_act_efd_v pjibaef,
pay_jp_itwb_sal_act_erd_v pjisaer,
pay_jp_itwb_bon_act_erd_v pjibaer,
pay_jp_itwb_bon_act_type_v pjibat,
pay_assignment_actions proc_paa,
pay_payroll_actions proc_ppa
where mpaa.payroll_action_id = p_payroll_action_id
and pjia.assignment_id = mpaa.assignment_id
and pjia.effective_date
between g_effective_soy and g_effective_eoy
and pjie.assignment_action_id = pjia.assignment_action_id
and pjie.effective_date = pjia.effective_date
and pjies.assignment_action_id = pjia.assignment_action_id
and pjies.effective_date = pjia.effective_date
and pjies.itax_org_id = g_itax_organization_id
and pjia.payroll_id = nvl(g_payroll_id,pjia.payroll_id)
and nvl(pjia.location_id,-1) = nvl(g_location_id,nvl(pjia.location_id,-1))
and (g_organization_id is null
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'Y'
and pjia.organization_id in (
select /*+ ORDERED */
distinct pose.organization_id_child
from per_organization_structures pos,
per_org_structure_versions posv,
per_org_structure_elements pose
where pos.business_group_id = decode(g_business_group_id,g_organization_id,-1,g_business_group_id)
and pos.primary_structure_flag = 'Y'
and posv.organization_structure_id = pos.organization_structure_id
and posv.date_from <= g_effective_eoy
and nvl(posv.date_to,hr_api.g_eot) >= g_effective_soy
and not exists(
select null
from per_org_structure_versions posv2
where posv2.organization_structure_id = pos.organization_structure_id
and posv2.date_from <= g_effective_eoy
and nvl(posv2.date_to,hr_api.g_eot) >= g_effective_soy
and posv2.version_number > posv.version_number)
and pose.org_structure_version_id = posv.org_structure_version_id
start with pose.organization_id_parent = g_organization_id
connect by prior pose.organization_id_child = pose.organization_id_parent
union
select hou.organization_id
from hr_all_organization_units hou
where hou.business_group_id = decode(g_business_group_id,g_organization_id,g_business_group_id,-1)
and hou.organization_id <> hou.business_group_id
union
select g_organization_id
from dual))
or (g_organization_id is not null
and nvl(g_inc_org_hier_flag,'N') = 'N'
and pjia.organization_id = g_organization_id))
and ((g_inc_term_flag = 'N'
and least(nvl(pjia.termination_date,g_effective_eoy + 1),g_effective_eoy + 1) > g_effective_eoy)
or (g_inc_term_flag = 'Y'
and ((g_term_date_from is null
and g_term_date_to is null)
or (pjia.termination_date
between nvl(g_term_date_from,pjia.termination_date) and nvl(g_term_date_to,pjia.termination_date)))))
and arch_paa.assignment_action_id = pjia.assignment_action_id
and pjiio.payroll_action_id = arch_paa.payroll_action_id
and pjiead.assignment_action_id = pjia.assignment_action_id
and pjiead.effective_date = pjia.effective_date
and pjieas.assignment_action_id = pjia.assignment_action_id
and pjieas.effective_date = pjia.effective_date
and pjid.assignment_action_id = pjia.assignment_action_id
and pjid.effective_date = pjia.effective_date
and pjiya.assignment_action_id = pjia.assignment_action_id
and pjiya.effective_date = pjia.effective_date
and pjiyp.assignment_action_id = pjia.assignment_action_id
and pjiyp.effective_date = pjia.effective_date
and pjiyd.assignment_action_id = pjia.assignment_action_id
and pjiyd.effective_date = pjia.effective_date
and pjiyt.assignment_action_id = pjia.assignment_action_id
and pjiyt.effective_date = pjia.effective_date
and pjisaef.assignment_action_id = pjia.assignment_action_id
and pjisaef.effective_date = pjia.effective_date
and pjibaef.assignment_action_id = pjia.assignment_action_id
and pjibaef.effective_date = pjia.effective_date
and pjisaer.assignment_action_id = pjia.assignment_action_id
and pjisaer.effective_date = pjia.effective_date
and pjibaer.assignment_action_id = pjia.assignment_action_id
and pjibaer.effective_date = pjia.effective_date
and pjibat.assignment_action_id = pjia.assignment_action_id
and pjibat.effective_date = pjia.effective_date
and proc_paa.assignment_action_id = pjia.proc_assignment_action_id
and proc_ppa.payroll_action_id = proc_paa.payroll_action_id
order by
decode(g_sort_order1,
'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
'ORGANIZATION_NAME',pjieas.organization_name,
lpad(pjie.employee_number,30,' ')),
decode(g_sort_order2,
'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
'ORGANIZATION_NAME',pjieas.organization_name,
lpad(pjie.employee_number,30,' ')),
decode(g_sort_order3,
'EMPLOYEE_NAME',pjie.last_name_kana||' '||pjie.first_name_kana,
'ORGANIZATION_NAME',pjieas.organization_name,
lpad(pjie.employee_number,30,' '));
select category,
col_mth1,
col_mth2,
col_mth3,
col_mth4,
col_mth5,
col_mth6,
col_mth7,
col_mth8,
col_mth9,
col_mth10,
col_mth11,
col_mth12,
col_tot
from pay_jp_itwb_sal_pay_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date;
select category,
col_cnt1,
col_cnt2,
col_cnt3,
col_cnt4,
col_cnt5,
col_cnt6,
col_cnt7,
col_cnt8,
col_cnt9,
col_cnt10,
col_cnt11,
col_cnt12,
col_cnt13,
col_cnt14,
col_cnt15,
col_tot
from pay_jp_itwb_bon_pay_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date;
select category,
col_cnt1,
col_cnt2,
col_cnt3,
col_cnt4,
col_cnt5,
col_cnt6,
col_cnt7,
col_cnt8,
col_cnt9,
col_cnt10,
col_cnt11,
col_cnt12,
col_cnt13,
col_cnt14,
col_cnt15,
col_tot
from pay_jp_itwb_bon_pay_itx_rate_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date;
select item_rep_name,
col_mth1,
col_mth2,
col_mth3,
col_mth4,
col_mth5,
col_mth6,
col_mth7,
col_mth8,
col_mth9,
col_mth10,
col_mth11,
col_mth12,
col_tot
from pay_jp_itwb_sal_earn_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
item_pay_ord desc,
item_rep_seq;
select item_rep_name,
col_mth1,
col_mth2,
col_mth3,
col_mth4,
col_mth5,
col_mth6,
col_mth7,
col_mth8,
col_mth9,
col_mth10,
col_mth11,
col_mth12,
col_tot
from pay_jp_itwb_sal_dct_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
item_pay_ord desc,
item_rep_seq;
select item_rep_name,
col_cnt1,
col_cnt2,
col_cnt3,
col_cnt4,
col_cnt5,
col_cnt6,
col_cnt7,
col_cnt8,
col_cnt9,
col_cnt10,
col_cnt11,
col_cnt12,
col_cnt13,
col_cnt14,
col_cnt15,
col_tot
from pay_jp_itwb_bon_earn_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
item_pay_ord desc,
item_rep_seq;
select item_rep_name,
col_cnt1,
col_cnt2,
col_cnt3,
col_cnt4,
col_cnt5,
col_cnt6,
col_cnt7,
col_cnt8,
col_cnt9,
col_cnt10,
col_cnt11,
col_cnt12,
col_cnt13,
col_cnt14,
col_cnt15,
col_tot
from pay_jp_itwb_bon_dct_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
item_pay_ord desc,
item_rep_seq;
select item_rep_name,
col_mth1,
col_mth2,
col_mth3,
col_mth4,
col_mth5,
col_mth6,
col_mth7,
col_mth8,
col_mth9,
col_mth10,
col_mth11,
col_mth12,
col_tot,
item_type,
item_id
from pay_jp_itwb_wrk_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
item_pay_ord desc,
item_rep_seq;
select term_date,
employer_name,
employer_name_kana,
employer_address,
employer_address_kana,
txbl_inc,
si_prem,
mutual_aid_prem,
itax
from pay_jp_itwb_pjob_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date
order by
term_date;
select data_type,
information1,
information2,
information3,
information4,
information5,
information6,
information7,
information8,
information9,
information10,
information11,
information12,
information13,
information14,
information15,
information16,
information17,
information18,
information19,
information20,
information21,
information22,
information23,
information24,
information25
from pay_jp_itwb_emp_cust_v
where assignment_action_id = p_assignment_action_id
and effective_date = p_effective_date;
g_iv_uom_tbl.delete;
g_dbal_uom_tbl.delete;
g_per_ind_tbl.delete;
g_ass_ind_tbl.delete;
g_ass_tbl.delete;
g_body_tbl.delete;
g_wng_tbl.delete;
l_data_ass_sal_earn_tbl.delete;
l_data_ass_sal_dct_tbl.delete;
l_data_ass_bon_earn_tbl.delete;
l_data_ass_bon_dct_tbl.delete;
l_data_ass_wrk_tbl.delete;
l_data_ass_pjob_tbl.delete;
g_iv_uom_tbl.delete;
g_dbal_uom_tbl.delete;
g_per_ind_tbl.delete;
g_ass_ind_tbl.delete;
g_ass_tbl.delete;
g_assact_tbl.delete;
g_body_tbl.delete;