[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
-- Bug 7439803: 2008 YEA Ledger Statutory Updates
p_non_taxable_ovs_frgn1 out nocopy number,
p_non_taxable_ovs_frgn2 out nocopy number,
p_non_taxable_ovs_frgn3 out nocopy number,
p_non_taxable_ovs_frgn4 out nocopy number,
p_non_taxable_ovs_frgn5 out nocopy number,
p_non_taxable_ovs_frgn6 out nocopy number,
p_non_taxable_ovs_frgn7 out nocopy number,
p_non_taxable_ovs_frgn8 out nocopy number,
p_non_taxable_ovs_frgn9 out nocopy number,
p_non_taxable_ovs_frgn10 out nocopy number,
p_non_taxable_ovs_frgn11 out nocopy number,
p_non_taxable_ovs_frgn12 out nocopy number,
p_non_taxable_ovs_frgn13 out nocopy number,
p_birth_raising_allow1 out nocopy number,
p_birth_raising_allow2 out nocopy number,
p_birth_raising_allow3 out nocopy number,
p_birth_raising_allow4 out nocopy number,
p_birth_raising_allow5 out nocopy number,
p_birth_raising_allow6 out nocopy number,
p_birth_raising_allow7 out nocopy number,
p_birth_raising_allow8 out nocopy number,
p_birth_raising_allow9 out nocopy number,
p_birth_raising_allow10 out nocopy number,
p_birth_raising_allow11 out nocopy number,
p_birth_raising_allow12 out nocopy number,
p_birth_raising_allow13 out nocopy number,
p_fw_income_exem1 out nocopy number,
p_fw_income_exem2 out nocopy number,
p_fw_income_exem3 out nocopy number,
p_fw_income_exem4 out nocopy number,
p_fw_income_exem5 out nocopy number,
p_fw_income_exem6 out nocopy number,
p_fw_income_exem7 out nocopy number,
p_fw_income_exem8 out nocopy number,
p_fw_income_exem9 out nocopy number,
p_fw_income_exem10 out nocopy number,
p_fw_income_exem11 out nocopy number,
p_fw_income_exem12 out nocopy number,
p_fw_income_exem13 out nocopy number,
-- End of Bug 7439803
-- Start of bug 8880364: 2009 YEA Ledger Updates
p_esop_with_drawn1 out nocopy number,
p_esop_with_drawn2 out nocopy number,
p_esop_with_drawn3 out nocopy number,
p_esop_with_drawn4 out nocopy number,
p_esop_with_drawn5 out nocopy number,
p_esop_with_drawn6 out nocopy number,
p_esop_with_drawn7 out nocopy number,
p_esop_with_drawn8 out nocopy number,
p_esop_with_drawn9 out nocopy number,
p_esop_with_drawn10 out nocopy number,
p_esop_with_drawn11 out nocopy number,
p_esop_with_drawn12 out nocopy number,
p_esop_with_drawn13 out nocopy number,
p_non_tax_18_earn1 out nocopy number,
p_non_tax_18_earn2 out nocopy number,
p_non_tax_18_earn3 out nocopy number,
p_non_tax_18_earn4 out nocopy number,
p_non_tax_18_earn5 out nocopy number,
p_non_tax_18_earn6 out nocopy number,
p_non_tax_18_earn7 out nocopy number,
p_non_tax_18_earn8 out nocopy number,
p_non_tax_18_earn9 out nocopy number,
p_non_tax_18_earn10 out nocopy number,
p_non_tax_18_earn11 out nocopy number,
p_non_tax_18_earn12 out nocopy number,
p_non_tax_18_earn13 out nocopy number,
p_non_tax_19_earn1 out nocopy number,
p_non_tax_19_earn2 out nocopy number,
p_non_tax_19_earn3 out nocopy number,
p_non_tax_19_earn4 out nocopy number,
p_non_tax_19_earn5 out nocopy number,
p_non_tax_19_earn6 out nocopy number,
p_non_tax_19_earn7 out nocopy number,
p_non_tax_19_earn8 out nocopy number,
p_non_tax_19_earn9 out nocopy number,
p_non_tax_19_earn10 out nocopy number,
p_non_tax_19_earn11 out nocopy number,
p_non_tax_19_earn12 out nocopy number,
p_non_tax_19_earn13 out nocopy number,
p_non_tax_20_earn1 out nocopy number,
p_non_tax_20_earn2 out nocopy number,
p_non_tax_20_earn3 out nocopy number,
p_non_tax_20_earn4 out nocopy number,
p_non_tax_20_earn5 out nocopy number,
p_non_tax_20_earn6 out nocopy number,
p_non_tax_20_earn7 out nocopy number,
p_non_tax_20_earn8 out nocopy number,
p_non_tax_20_earn9 out nocopy number,
p_non_tax_20_earn10 out nocopy number,
p_non_tax_20_earn11 out nocopy number,
p_non_tax_20_earn12 out nocopy number,
p_non_tax_20_earn13 out nocopy number,
p_non_taxable1 out nocopy number,
p_non_taxable2 out nocopy number,
p_non_taxable3 out nocopy number,
p_non_taxable4 out nocopy number,
p_non_taxable5 out nocopy number,
p_non_taxable6 out nocopy number,
p_non_taxable7 out nocopy number,
p_non_taxable8 out nocopy number,
p_non_taxable9 out nocopy number,
p_non_taxable10 out nocopy number,
p_non_taxable11 out nocopy number,
p_non_taxable12 out nocopy number,
p_non_taxable13 out nocopy number,
-- Bug 10082074
p_emp_hire_date out nocopy date,
p_emp_leaving_date out nocopy date,
p_rep_non_tax_oth1 out nocopy number,
p_rep_non_tax_oth2 out nocopy number,
p_rep_non_tax_oth3 out nocopy number,
p_rep_non_tax_oth4 out nocopy number,
p_rep_non_tax_oth5 out nocopy number,
p_rep_non_tax_oth6 out nocopy number,
p_rep_non_tax_oth7 out nocopy number,
p_rep_non_tax_oth8 out nocopy number,
p_rep_non_tax_oth9 out nocopy number,
p_rep_non_tax_oth10 out nocopy number,
p_rep_non_tax_oth11 out nocopy number,
p_rep_non_tax_oth12 out nocopy number,
p_rep_non_tax_oth13 out nocopy number,
p_spec_non_taxable1 out nocopy number,
p_spec_non_taxable2 out nocopy number,
p_spec_non_taxable3 out nocopy number,
p_spec_non_taxable4 out nocopy number,
p_spec_non_taxable5 out nocopy number,
p_spec_non_taxable6 out nocopy number,
p_spec_non_taxable7 out nocopy number,
p_spec_non_taxable8 out nocopy number,
p_spec_non_taxable9 out nocopy number,
p_spec_non_taxable10 out nocopy number,
p_spec_non_taxable11 out nocopy number,
p_spec_non_taxable12 out nocopy number,
p_spec_non_taxable13 out nocopy number,
p_rep_non_tax_total1 out nocopy number,
p_rep_non_tax_total2 out nocopy number,
p_rep_non_tax_total3 out nocopy number,
p_rep_non_tax_total4 out nocopy number,
p_rep_non_tax_total5 out nocopy number,
p_rep_non_tax_total6 out nocopy number,
p_rep_non_tax_total7 out nocopy number,
p_rep_non_tax_total8 out nocopy number,
p_rep_non_tax_total9 out nocopy number,
p_rep_non_tax_total10 out nocopy number,
p_rep_non_tax_total11 out nocopy number,
p_rep_non_tax_total12 out nocopy number,
p_rep_non_tax_total13 out nocopy number,
p_foreign_worker_tax_break out nocopy number,
p_non_taxable_ovs_M01 out nocopy number,
p_non_taxable_ovs_M02 out nocopy number,
p_non_taxable_ovs_M03 out nocopy number,
p_non_taxable_ovs_code out nocopy varchar2,
p_non_tax_H02_earn1 out nocopy number,
p_non_tax_H02_earn2 out nocopy number,
p_non_tax_H02_earn3 out nocopy number,
p_non_tax_H02_earn4 out nocopy number,
p_non_tax_H02_earn5 out nocopy number,
p_non_tax_H02_earn6 out nocopy number,
p_non_tax_H02_earn7 out nocopy number,
p_non_tax_H02_earn8 out nocopy number,
p_non_tax_H02_earn9 out nocopy number,
p_non_tax_H02_earn10 out nocopy number,
p_non_tax_H02_earn11 out nocopy number,
p_non_tax_H02_earn12 out nocopy number,
p_non_tax_H02_earn13 out nocopy number,
p_non_tax_H03_earn1 out nocopy number,
p_non_tax_H03_earn2 out nocopy number,
p_non_tax_H03_earn3 out nocopy number,
p_non_tax_H03_earn4 out nocopy number,
p_non_tax_H03_earn5 out nocopy number,
p_non_tax_H03_earn6 out nocopy number,
p_non_tax_H03_earn7 out nocopy number,
p_non_tax_H03_earn8 out nocopy number,
p_non_tax_H03_earn9 out nocopy number,
p_non_tax_H03_earn10 out nocopy number,
p_non_tax_H03_earn11 out nocopy number,
p_non_tax_H03_earn12 out nocopy number,
p_non_tax_H03_earn13 out nocopy number,
p_unrep_non_tax_tot1 out nocopy number,
p_unrep_non_tax_tot2 out nocopy number,
p_unrep_non_tax_tot3 out nocopy number,
p_unrep_non_tax_tot4 out nocopy number,
p_unrep_non_tax_tot5 out nocopy number,
p_unrep_non_tax_tot6 out nocopy number,
p_unrep_non_tax_tot7 out nocopy number,
p_unrep_non_tax_tot8 out nocopy number,
p_unrep_non_tax_tot9 out nocopy number,
p_unrep_non_tax_tot10 out nocopy number,
p_unrep_non_tax_tot11 out nocopy number,
p_unrep_non_tax_tot12 out nocopy number,
p_unrep_non_tax_tot13 out nocopy number,
p_exchange_rate1 out nocopy varchar2,
p_exchange_rate2 out nocopy varchar2,
p_exchange_rate3 out nocopy varchar2,
p_exchange_rate4 out nocopy varchar2,
p_exchange_rate5 out nocopy varchar2,
p_exchange_rate6 out nocopy varchar2,
p_exchange_rate7 out nocopy varchar2,
p_exchange_rate8 out nocopy varchar2,
p_exchange_rate9 out nocopy varchar2,
p_exchange_rate10 out nocopy varchar2,
p_exchange_rate11 out nocopy varchar2,
p_exchange_rate12 out nocopy varchar2,
p_fw_tax_break_earn1 out nocopy number,
p_fw_tax_break_earn2 out nocopy number,
p_fw_tax_break_earn3 out nocopy number,
p_fw_tax_break_earn4 out nocopy number,
p_fw_tax_break_earn5 out nocopy number,
p_fw_tax_break_earn6 out nocopy number,
p_fw_tax_break_earn7 out nocopy number,
p_fw_tax_break_earn8 out nocopy number,
p_fw_tax_break_earn9 out nocopy number,
p_fw_tax_break_earn10 out nocopy number,
p_fw_tax_break_earn11 out nocopy number,
p_fw_tax_break_earn12 out nocopy number,
p_fw_tax_break_earn13 out nocopy number
)
------------------------------------------------------------------------
is
l_yea_info pay_kr_yea_pkg.t_yea_info;
select
pai.locked_action_id bal_adj_assact
from
pay_action_interlocks pai,
pay_assignment_actions paa,
pay_payroll_actions ppa
where
pai.locking_action_id = p_assignment_action_id
and paa.assignment_action_id = pai.locked_action_id
and paa.action_status = 'C'
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.action_type = 'B'
and pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'REPORT_TYPE', null)
= 'YEA' ;
select
paa2.assignment_action_id,
ppa2.effective_date
from pay_payroll_actions ppa2,
pay_assignment_actions paa2,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_bal_adj_assact
and ppa.payroll_action_id = paa.payroll_action_id
and paa2.assignment_id = paa.assignment_id
and paa2.action_sequence < paa.action_sequence
and paa2.source_action_id is null
and ppa2.payroll_action_id = paa2.payroll_action_id
and ( ppa2.action_type in ('I', 'R', 'Q', 'V') or ( ppa2.action_type ='B' and nvl(pay_core_utils.get_parameter('REPORT_TYPE',ppa2.legislative_parameters),'XYZ') <> 'YEA'))
and trunc(ppa2.effective_date, 'YYYY') = trunc(ppa.effective_date, 'YYYY')
order by paa2.action_sequence desc;
select hr_ni_chk_pkg.chk_nat_id_format(per.national_identifier, 'DDDDDD-DDDDDDD') NATIONAL_IDENTIFIER,
per.person_id, -- bug 6012258
pds.date_start,
pds.actual_termination_date,
ppa.effective_date
from per_people_f per,
per_periods_of_service pds,
per_assignments_f asg,
pay_payroll_actions ppa,
pay_assignment_actions paa
where paa.assignment_action_id = p_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and asg.assignment_id = paa.assignment_id
and ppa.effective_date
between asg.effective_start_date and asg.effective_end_date
and pds.period_of_service_id = asg.period_of_service_id
and per.person_id = pds.person_id
and ppa.effective_date
between per.effective_start_date and per.effective_end_date;
-- Bug 7439803: 2008 YEA Ledger Statutory Updates
function get_globalvalue(p_glbvar in varchar2,p_process_date in date) return number
-----------------------------------------------------------------------------------
is
--
cursor csr_ff_global
is
select to_number(glb.global_value,'99999999999999999999.99999') -- Bug 5726158
from ff_globals_f glb
where glb.global_name = p_glbvar
and p_process_date between glb.effective_start_date and glb.effective_end_date;
-- Bug 7439803: 2008 YEA Ledger Statutory Updates
t_balance_batch(33).defined_balance_id := g_defined_balance_id.non_taxable_ovs_frgn_mth;
-- Bug 8880364: 2009 YEA ledger Updates
t_balance_batch(39).defined_balance_id := g_defined_balance_id.esop_with_drawn_mth;
select
u.creator_id
into l_defined_balance_id
from ff_user_entities u,
ff_database_items d
where d.user_name = p_user_name
and u.user_entity_id = d.user_entity_id
and u.legislation_code = 'KR'
and u.business_group_id is null
and u.creator_type = 'B';
select to_number(glb.global_value,'99999999999999999999.99999') -- Bug 5726158
from ff_globals_f glb
where glb.global_name = p_glbvar
and p_process_date between glb.effective_start_date and glb.effective_end_date;
-- Bug 7439803: 2008 YEA Ledger Statutory Updates
g_defined_balance_id.non_taxable_ovs_frgn_mth := defined_balance_id('NON_TAXABLE_OVS_FRGN_EARNINGS_ASG_MTD_MTH');
-- Bug 8880364:2009 YEA Ledger Statutory Updates
g_defined_balance_id.esop_with_drawn_mth := defined_balance_id('ESOP_WITHDRAWAL_EARNINGS_ASG_MTD_MTH') ;