[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pdb.defined_balance_id
FROM pay_balance_types pbt,
pay_defined_balances pdb,
pay_balance_dimensions pbd
WHERE pbt.balance_name like 'Overseas Earnings'
and pbt.legislation_code = 'KR'
and pbd.legislation_code = 'KR'
and pdb.legislation_code = 'KR'
and pbt.balance_type_id = pdb.balance_type_id
and pbd.balance_dimension_id = pdb.balance_dimension_id
and pbd.database_item_suffix = '_ASG_YTD';
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;
-- Also, p_yea_info.educ_exp_tax_exem may still change. Hence, updated value of educ_exp_tax_exem
-- would be added to l_cuml_special_exem later.
--
p_yea_info.educ_exp_tax_exem := p_yea_info.educ_exp_tax_exem + p_yea_info.ee_occupation_educ_exp2005 ;
-- Bug 5682450: Updated Political Donation Tax Break
p_yea_info.don_tax_break2004 := (greatest(0, p_yea_info.political_donation1) - greatest(0, p_yea_info.political_donation1 - l_political_tax_brk_lim2004 )) / l_pol_don_exem_rate_factor ;
-- Bug 7615517: Updated Total Credit Card amount for Company Related Expenses
p_yea_info.total_credit_card_exp :=p_yea_info.emp_cre_card_direct_exp2004
+ p_yea_info.dpnt_cre_card_direct_exp2004
+ p_yea_info.giro_tuition_paid_exp2004
+ p_yea_info.cash_receipt_exp2005
- p_yea_info.company_related_exp ;