eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_JP_WIC_PKG dependencies on PAY_JP_BALANCE_PKG

Line 301: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_adj_iv, p_assignment_action_id), 0);

297: if p_itax_yea_category <> '-1' then
298: hr_utility.set_location(c_proc, 21);
299: --
300: p_withholding_tax_info.taxable_income := p_withholding_tax_info.taxable_income
301: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_adj_iv, p_assignment_action_id), 0);
302: p_withholding_tax_info.si_prem := p_withholding_tax_info.si_prem
303: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.si_prem_adj_iv, p_assignment_action_id), 0);
304: p_withholding_tax_info.mutual_aid_prem := p_withholding_tax_info.mutual_aid_prem
305: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.mutual_aid_prem_adj_iv, p_assignment_action_id), 0);

Line 303: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.si_prem_adj_iv, p_assignment_action_id), 0);

299: --
300: p_withholding_tax_info.taxable_income := p_withholding_tax_info.taxable_income
301: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_adj_iv, p_assignment_action_id), 0);
302: p_withholding_tax_info.si_prem := p_withholding_tax_info.si_prem
303: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.si_prem_adj_iv, p_assignment_action_id), 0);
304: p_withholding_tax_info.mutual_aid_prem := p_withholding_tax_info.mutual_aid_prem
305: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.mutual_aid_prem_adj_iv, p_assignment_action_id), 0);
306: p_withholding_tax_info.itax := p_withholding_tax_info.itax
307: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);

Line 305: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.mutual_aid_prem_adj_iv, p_assignment_action_id), 0);

301: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_adj_iv, p_assignment_action_id), 0);
302: p_withholding_tax_info.si_prem := p_withholding_tax_info.si_prem
303: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.si_prem_adj_iv, p_assignment_action_id), 0);
304: p_withholding_tax_info.mutual_aid_prem := p_withholding_tax_info.mutual_aid_prem
305: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.mutual_aid_prem_adj_iv, p_assignment_action_id), 0);
306: p_withholding_tax_info.itax := p_withholding_tax_info.itax
307: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
308: end if;
309: --

Line 307: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);

303: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.si_prem_adj_iv, p_assignment_action_id), 0);
304: p_withholding_tax_info.mutual_aid_prem := p_withholding_tax_info.mutual_aid_prem
305: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.mutual_aid_prem_adj_iv, p_assignment_action_id), 0);
306: p_withholding_tax_info.itax := p_withholding_tax_info.itax
307: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
308: end if;
309: --
310: p_withholding_tax_info.mutual_aid_prem := decode_value(p_withholding_tax_info.mutual_aid_prem <> 0, p_withholding_tax_info.mutual_aid_prem);
311: p_withholding_tax_info.disaster_tax_reduction := decode_value(p_withholding_tax_info.disaster_tax_reduction <> 0, p_withholding_tax_info.disaster_tax_reduction);

Line 716: p_certificate_info.taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_iv, p_assignment_action_id), 0);

712: --
713: if p_itax_yea_category = '0' then
714: hr_utility.set_location(c_proc, 21);
715: --
716: p_certificate_info.taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_iv, p_assignment_action_id), 0);
717: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);
718: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);
719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*

Line 717: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);

713: if p_itax_yea_category = '0' then
714: hr_utility.set_location(c_proc, 21);
715: --
716: p_certificate_info.taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_iv, p_assignment_action_id), 0);
717: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);
718: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);
719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*
721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)

Line 719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);

715: --
716: p_certificate_info.taxable_income := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.taxable_income_iv, p_assignment_action_id), 0);
717: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);
718: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);
719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*
721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)
722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);

Line 721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)

717: p_certificate_info.mutual_aid_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.mutual_aid_prem_iv, p_assignment_action_id), 0);
718: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);
719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*
721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)
722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
724: */
725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);

Line 722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)

718: p_certificate_info.mutual_aid_prem := decode_value(p_certificate_info.mutual_aid_prem <> 0, p_certificate_info.mutual_aid_prem);
719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*
721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)
722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
724: */
725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);
726: p_certificate_info.withholding_itax := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id, g_net_annual_itax_elm.net_annual_itax_iv, p_assignment_action_id), 0);

Line 723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);

719: p_certificate_info.si_prem := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id, g_ins_prem_exempt_elm.si_prem_iv, p_assignment_action_id), 0);
720: /*
721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)
722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
724: */
725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);
726: p_certificate_info.withholding_itax := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id, g_net_annual_itax_elm.net_annual_itax_iv, p_assignment_action_id), 0);
727: p_certificate_info.itax := p_certificate_info.withholding_itax - p_certificate_info.itax_adjustment;

Line 725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);

721: p_certificate_info.itax := pay_jp_balance_pkg.get_balance_value(g_itax_asg_ytd, p_assignment_action_id)
722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
724: */
725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);
726: p_certificate_info.withholding_itax := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id, g_net_annual_itax_elm.net_annual_itax_iv, p_assignment_action_id), 0);
727: p_certificate_info.itax := p_certificate_info.withholding_itax - p_certificate_info.itax_adjustment;
728: --
729: -- No need to calculate Disaster Tax Reduction in case of YEA because it should be ZERO.

Line 726: p_certificate_info.withholding_itax := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id, g_net_annual_itax_elm.net_annual_itax_iv, p_assignment_action_id), 0);

722: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.prev_itax_iv, p_assignment_action_id), 0)
723: + nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id, g_taxable_income_exempt_elm.itax_adj_iv, p_assignment_action_id), 0);
724: */
725: p_certificate_info.itax_adjustment := pay_jp_balance_pkg.get_balance_value(g_itax_adjustment_asg_ytd, p_assignment_action_id);
726: p_certificate_info.withholding_itax := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id, g_net_annual_itax_elm.net_annual_itax_iv, p_assignment_action_id), 0);
727: p_certificate_info.itax := p_certificate_info.withholding_itax - p_certificate_info.itax_adjustment;
728: --
729: -- No need to calculate Disaster Tax Reduction in case of YEA because it should be ZERO.
730: --

Line 2525: := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id,g_taxable_income_exempt_elm.net_taxable_income_iv,p_assignment_action_id),0);

2521: --
2522: hr_utility.set_location(c_proc, 21);
2523: --
2524: p_certificate_info.net_taxable_income
2525: := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id,g_taxable_income_exempt_elm.net_taxable_income_iv,p_assignment_action_id),0);
2526: --
2527: p_certificate_info.spouse_sp_exempt
2528: := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.spouse_sp_exempt_iv,p_assignment_action_id),0);
2529: --

Line 2528: := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.spouse_sp_exempt_iv,p_assignment_action_id),0);

2524: p_certificate_info.net_taxable_income
2525: := nvl(pay_jp_balance_pkg.get_result_value_number(g_taxable_income_exempt_elm.element_type_id,g_taxable_income_exempt_elm.net_taxable_income_iv,p_assignment_action_id),0);
2526: --
2527: p_certificate_info.spouse_sp_exempt
2528: := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.spouse_sp_exempt_iv,p_assignment_action_id),0);
2529: --
2530: if p_certificate_info.spouse_sp_exempt <> 0 then
2531: --
2532: p_certificate_info.spouse_net_taxable_income

Line 2533: := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.spouse_net_taxable_income_iv,p_assignment_action_id),0);

2529: --
2530: if p_certificate_info.spouse_sp_exempt <> 0 then
2531: --
2532: p_certificate_info.spouse_net_taxable_income
2533: := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.spouse_net_taxable_income_iv,p_assignment_action_id),0);
2534: --
2535: end if;
2536: --
2537: -- Date: 2007/06/07

Line 2540: p_certificate_info.li_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.li_prem_exempt_iv,p_assignment_action_id),0);

2536: --
2537: -- Date: 2007/06/07
2538: -- "Personal Pension Premium" should be printed only when "Personal Pension Premium" <> 0.
2539: --
2540: p_certificate_info.li_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.li_prem_exempt_iv,p_assignment_action_id),0);
2541: --
2542: if p_certificate_info.li_prem_exempt <> 0 then
2543: --
2544: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.pp_prem_iv,p_assignment_action_id),0);

Line 2544: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.pp_prem_iv,p_assignment_action_id),0);

2540: p_certificate_info.li_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.li_prem_exempt_iv,p_assignment_action_id),0);
2541: --
2542: if p_certificate_info.li_prem_exempt <> 0 then
2543: --
2544: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.pp_prem_iv,p_assignment_action_id),0);
2545: --
2546: if l_dummy_number <> 0 then
2547: --
2548: p_certificate_info.pp_prem := l_dummy_number;

Line 2553: l_dummy_old_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.old_life_ins_prem_iv,p_assignment_action_id),0);

2549: --
2550: end if;
2551: -- Date: 2012/09/26 2012 Withholding Changes
2552: -- "Old Life Insurance Premium"
2553: l_dummy_old_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.old_life_ins_prem_iv,p_assignment_action_id),0);
2554: l_dummy_new_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_life_ins_prem_iv,p_assignment_action_id),0);
2555: l_dummy_new_pension := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_pen_ins_prem_iv,p_assignment_action_id),0);
2556: l_dummy_care_med := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.care_med_ins_prem_iv,p_assignment_action_id),0);
2557:

Line 2554: l_dummy_new_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_life_ins_prem_iv,p_assignment_action_id),0);

2550: end if;
2551: -- Date: 2012/09/26 2012 Withholding Changes
2552: -- "Old Life Insurance Premium"
2553: l_dummy_old_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.old_life_ins_prem_iv,p_assignment_action_id),0);
2554: l_dummy_new_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_life_ins_prem_iv,p_assignment_action_id),0);
2555: l_dummy_new_pension := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_pen_ins_prem_iv,p_assignment_action_id),0);
2556: l_dummy_care_med := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.care_med_ins_prem_iv,p_assignment_action_id),0);
2557:
2558: if l_dummy_old_life <> 0 then

Line 2555: l_dummy_new_pension := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_pen_ins_prem_iv,p_assignment_action_id),0);

2551: -- Date: 2012/09/26 2012 Withholding Changes
2552: -- "Old Life Insurance Premium"
2553: l_dummy_old_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.old_life_ins_prem_iv,p_assignment_action_id),0);
2554: l_dummy_new_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_life_ins_prem_iv,p_assignment_action_id),0);
2555: l_dummy_new_pension := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_pen_ins_prem_iv,p_assignment_action_id),0);
2556: l_dummy_care_med := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.care_med_ins_prem_iv,p_assignment_action_id),0);
2557:
2558: if l_dummy_old_life <> 0 then
2559: p_certificate_info.old_life_ins_prem := l_dummy_old_life;

Line 2556: l_dummy_care_med := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.care_med_ins_prem_iv,p_assignment_action_id),0);

2552: -- "Old Life Insurance Premium"
2553: l_dummy_old_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.old_life_ins_prem_iv,p_assignment_action_id),0);
2554: l_dummy_new_life := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_life_ins_prem_iv,p_assignment_action_id),0);
2555: l_dummy_new_pension := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.new_pen_ins_prem_iv,p_assignment_action_id),0);
2556: l_dummy_care_med := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm_new.element_type_id,g_ins_prem_exempt_elm_new.care_med_ins_prem_iv,p_assignment_action_id),0);
2557:
2558: if l_dummy_old_life <> 0 then
2559: p_certificate_info.old_life_ins_prem := l_dummy_old_life;
2560: end if;

Line 2576: p_certificate_info.ai_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.ai_prem_exempt_iv,p_assignment_action_id),0);

2572: --
2573: -- Date: 2007/06/07
2574: -- "Long-term Accident Insurance Premium" should be printed only when "Long-term Accident Insurance Premium" <> 0.
2575: --
2576: p_certificate_info.ai_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.ai_prem_exempt_iv,p_assignment_action_id),0);
2577: --
2578: if p_certificate_info.ai_prem_exempt <> 0 then
2579: --
2580: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.long_ai_prem_iv,p_assignment_action_id),0);

Line 2580: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.long_ai_prem_iv,p_assignment_action_id),0);

2576: p_certificate_info.ai_prem_exempt := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.ai_prem_exempt_iv,p_assignment_action_id),0);
2577: --
2578: if p_certificate_info.ai_prem_exempt <> 0 then
2579: --
2580: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_ins_prem_exempt_elm.element_type_id,g_ins_prem_exempt_elm.long_ai_prem_iv,p_assignment_action_id),0);
2581: --
2582: if l_dummy_number <> 0 then
2583: --
2584: p_certificate_info.long_ai_prem := l_dummy_number;

Line 2590: p_certificate_info.total_income_exempt := pay_jp_balance_pkg.get_balance_value(g_total_income_exempt_asg_run, p_assignment_action_id);

2586: end if;
2587: --
2588: end if;
2589: --
2590: p_certificate_info.total_income_exempt := pay_jp_balance_pkg.get_balance_value(g_total_income_exempt_asg_run, p_assignment_action_id);
2591: --
2592: -- Date: 2007/06/07
2593: -- There's possibility when "Housing Tax Reduction" > 0, but "Net Housing Tax Reduction" = 0.
2594: -- This occurs when annual tax is zero. In this case, "Housing Tax Reduction Information" should

Line 2598: := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.net_housing_tax_reduction_iv,p_assignment_action_id),0);

2594: -- This occurs when annual tax is zero. In this case, "Housing Tax Reduction Information" should
2595: -- be printed on "Description" field.
2596: --
2597: p_certificate_info.housing_tax_reduction
2598: := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.net_housing_tax_reduction_iv,p_assignment_action_id),0);
2599: --
2600: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.housing_tax_reduction_iv,p_assignment_action_id),0);
2601: --
2602: if l_dummy_number <> 0 then

Line 2600: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.housing_tax_reduction_iv,p_assignment_action_id),0);

2596: --
2597: p_certificate_info.housing_tax_reduction
2598: := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.net_housing_tax_reduction_iv,p_assignment_action_id),0);
2599: --
2600: l_dummy_number := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.housing_tax_reduction_iv,p_assignment_action_id),0);
2601: --
2602: if l_dummy_number <> 0 then
2603: --
2604: if to_number(to_char(p_effective_date,'YYYY')) < 2009

Line 2608: p_certificate_info.housing_residence_date := pay_jp_balance_pkg.get_entry_value_date(g_housing_tax_reduction_elm.residence_date_iv,p_assignment_id,p_date_earned);

2604: if to_number(to_char(p_effective_date,'YYYY')) < 2009
2605: or (to_number(to_char(p_effective_date,'YYYY')) = 2009
2606: and to_number(to_char(p_effective_date,'MM')) < 4) then
2607: --
2608: p_certificate_info.housing_residence_date := pay_jp_balance_pkg.get_entry_value_date(g_housing_tax_reduction_elm.residence_date_iv,p_assignment_id,p_date_earned);
2609: --
2610: end if;
2611: --
2612: p_certificate_info.unclaimed_housing_tax_reduct := l_dummy_number - p_certificate_info.housing_tax_reduction;

Line 2619: := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.fixed_rate_tax_reduction_iv,p_assignment_action_id),0);

2615: --
2616: if to_number(to_char(p_effective_date, 'YYYY')) <= 2006 then
2617: --
2618: p_certificate_info.fixed_rate_tax_reduction
2619: := nvl(pay_jp_balance_pkg.get_result_value_number(g_net_annual_itax_elm.element_type_id,g_net_annual_itax_elm.fixed_rate_tax_reduction_iv,p_assignment_action_id),0);
2620: --
2621: else
2622: --
2623: p_certificate_info.fixed_rate_tax_reduction := 0;

Line 2629: p_certificate_info.national_pens_prem := nvl(pay_jp_balance_pkg.get_entry_value_number(g_yea_ins_prem_sp_exm_info_elm.national_pens_prem_iv,p_assignment_id,p_date_earned),0);

2625: end if;
2626: --
2627: if to_number(to_char(p_effective_date, 'YYYY')) >= 2005 then
2628: --
2629: p_certificate_info.national_pens_prem := nvl(pay_jp_balance_pkg.get_entry_value_number(g_yea_ins_prem_sp_exm_info_elm.national_pens_prem_iv,p_assignment_id,p_date_earned),0);
2630: --
2631: else
2632: --
2633: p_certificate_info.national_pens_prem := 0;

Line 2682: l_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.disabled_iv,p_assignment_action_id),'0');

2678: if p_itax_yea_category = '0' then
2679: --
2680: hr_utility.set_location(c_proc, 31);
2681: --
2682: l_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.disabled_iv,p_assignment_action_id),'0');
2683: --
2684: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
2685: --
2686: l_aged_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.aged_iv,p_assignment_action_id),'0');

Line 2686: l_aged_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.aged_iv,p_assignment_action_id),'0');

2682: l_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.disabled_iv,p_assignment_action_id),'0');
2683: --
2684: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
2685: --
2686: l_aged_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.aged_iv,p_assignment_action_id),'0');
2687: --
2688: end if;
2689: --
2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');

Line 2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');

2686: l_aged_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.aged_iv,p_assignment_action_id),'0');
2687: --
2688: end if;
2689: --
2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');
2691: l_working_student_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.working_student_iv,p_assignment_action_id),'0');
2692: --
2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');

Line 2691: l_working_student_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.working_student_iv,p_assignment_action_id),'0');

2687: --
2688: end if;
2689: --
2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');
2691: l_working_student_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.working_student_iv,p_assignment_action_id),'0');
2692: --
2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --

Line 2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');

2689: --
2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');
2691: l_working_student_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.working_student_iv,p_assignment_action_id),'0');
2692: --
2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);

Line 2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');

2690: l_widow_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.widow_iv,p_assignment_action_id),'0');
2691: l_working_student_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.working_student_iv,p_assignment_action_id),'0');
2692: --
2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);

Line 2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);

2692: --
2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);

Line 2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);

2693: l_spouse_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_type_iv,p_assignment_action_id),'0');
2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);

Line 2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);

2694: l_spouse_disabled_type := nvl(pay_jp_balance_pkg.get_result_value_char(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.spouse_disabled_iv,p_assignment_action_id),'0');
2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);
2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);

Line 2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);

2695: --
2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);
2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);
2703: --

Line 2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);

2696: l_num_deps := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_deps_iv,p_assignment_action_id),0);
2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);
2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);
2703: --
2704: else

Line 2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);

2697: l_num_ageds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_ageds_iv,p_assignment_action_id),0);
2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);
2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);
2703: --
2704: else
2705: --

Line 2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);

2698: l_num_aged_parents_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_aged_parents_lt_iv,p_assignment_action_id),0);
2699: l_num_specifieds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_specifieds_iv,p_assignment_action_id),0);
2700: l_num_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_disableds_iv,p_assignment_action_id),0);
2701: l_num_svr_disableds := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_iv,p_assignment_action_id),0);
2702: l_num_svr_disableds_lt := nvl(pay_jp_balance_pkg.get_result_value_number(g_dep_exempt_result_elm.element_type_id,g_dep_exempt_result_elm.num_svr_disableds_lt_iv,p_assignment_action_id),0);
2703: --
2704: else
2705: --
2706: hr_utility.set_location(c_proc, 32);

Line 2708: l_disabled_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.disabled_iv,p_assignment_id,p_date_earned),'0');

2704: else
2705: --
2706: hr_utility.set_location(c_proc, 32);
2707: --
2708: l_disabled_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.disabled_iv,p_assignment_id,p_date_earned),'0');
2709: --
2710: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
2711: --
2712: l_aged_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.aged_iv,p_assignment_id,p_date_earned),'0');

Line 2712: l_aged_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.aged_iv,p_assignment_id,p_date_earned),'0');

2708: l_disabled_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.disabled_iv,p_assignment_id,p_date_earned),'0');
2709: --
2710: if to_number(to_char(p_effective_date,'YYYY')) < 2005 then
2711: --
2712: l_aged_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.aged_iv,p_assignment_id,p_date_earned),'0');
2713: --
2714: end if;
2715: --
2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');

Line 2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');

2712: l_aged_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.aged_iv,p_assignment_id,p_date_earned),'0');
2713: --
2714: end if;
2715: --
2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');
2717: l_working_student_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.working_student_iv,p_assignment_id,p_date_earned),'0');
2718: --
2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);

Line 2717: l_working_student_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.working_student_iv,p_assignment_id,p_date_earned),'0');

2713: --
2714: end if;
2715: --
2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');
2717: l_working_student_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.working_student_iv,p_assignment_id,p_date_earned),'0');
2718: --
2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --

Line 2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);

2715: --
2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');
2717: l_working_student_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.working_student_iv,p_assignment_id,p_date_earned),'0');
2718: --
2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);

Line 2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);

2716: l_widow_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.widow_iv,p_assignment_id,p_date_earned),'0');
2717: l_working_student_type := nvl(pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.working_student_iv,p_assignment_id,p_date_earned),'0');
2718: --
2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);

Line 2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);

2718: --
2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);

Line 2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);

2719: l_spouse_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_type_iv,p_assignment_id,p_date_earned);
2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);

Line 2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);

2720: l_spouse_disabled_type := pay_jp_balance_pkg.get_entry_value_char(g_dep_exempt_elm.spouse_disabled_iv,p_assignment_id,p_date_earned);
2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);
2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);

Line 2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);

2721: --
2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);
2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);
2729: --

Line 2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);

2722: l_num_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_deps_iv,p_assignment_id,p_date_earned);
2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);
2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);
2729: --
2730: -- Derive Dependent Information based on Income Tax Dependent Control Method.

Line 2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);

2723: l_num_ageds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_ageds_iv,p_assignment_id,p_date_earned);
2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);
2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);
2729: --
2730: -- Derive Dependent Information based on Income Tax Dependent Control Method.
2731: -- This flag is set at "Payroll Developer DF" or "Org Developer DF"(Business Group level).

Line 2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);

2724: l_num_aged_parents_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_aged_parents_lt_iv,p_assignment_id,p_date_earned);
2725: l_num_specifieds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_specifieds_iv,p_assignment_id,p_date_earned);
2726: l_num_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_disableds_iv,p_assignment_id,p_date_earned);
2727: l_num_svr_disableds := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_iv,p_assignment_id,p_date_earned);
2728: l_num_svr_disableds_lt := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_svr_disableds_lt_iv,p_assignment_id,p_date_earned);
2729: --
2730: -- Derive Dependent Information based on Income Tax Dependent Control Method.
2731: -- This flag is set at "Payroll Developer DF" or "Org Developer DF"(Business Group level).
2732: -- The value set in "Payroll Developer DF" has higher priority than "Org Developer DF".

Line 2788: l_num_junior_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_junior_deps_iv,p_assignment_id,p_date_earned);

2784: end if;
2785: --
2786: if to_number(to_char(p_effective_date,'YYYY')) >= 2011 then
2787: --
2788: l_num_junior_deps := pay_jp_balance_pkg.get_entry_value_number(g_dep_exempt_elm.num_junior_deps_iv,p_assignment_id,p_date_earned);
2789: --
2790: if p_dpnt_ref_type = 'CEI' then
2791: --
2792: if l_num_junior_deps is null then

Line 3024: if pay_jp_balance_pkg.get_entry_value_char(g_itax_info_elm.foreigner_flag_iv, p_assignment_id, p_date_earned) = 'Y' then

3020: --
3021: -- Foreigner
3022: --
3023: --
3024: if pay_jp_balance_pkg.get_entry_value_char(g_itax_info_elm.foreigner_flag_iv, p_assignment_id, p_date_earned) = 'Y' then
3025: --
3026: p_certificate_info.foreigner_flag := 'Y';
3027: --
3028: end if;