[Home] [Help]
3866: hr_utility.set_location('l_payroll_id '|| l_payroll_id,22);
3867: hr_utility.set_location('p_business_group_id '|| p_business_group_id,22);
3868: hr_utility.set_location('p_effective_date '|| p_effective_date,22);
3869:
3870: l_no_of_periods := ben_distribute_rates.get_periods_between(
3871: p_acty_ref_perd_cd => 'PP',
3872: p_start_date => l_last_pp_strt_dt,
3873: p_end_date => l_last_pp_end_dt,
3874: p_payroll_id => l_payroll_id,
3888: hr_utility.set_location('l_payroll_id '|| l_payroll_id,22);
3889: hr_utility.set_location('p_business_group_id '|| p_business_group_id,22);
3890: hr_utility.set_location('p_effective_date '|| p_effective_date,22);
3891:
3892: l_no_of_prev_py_periods := ben_distribute_rates.get_periods_between(
3893: p_acty_ref_perd_cd => 'PP',
3894: p_start_date => l_prev_yp_start_date,
3895: p_end_date => (p_rt_start_date-1),
3896: p_payroll_id => l_payroll_id,
4763: end if;
4764: end if;
4765: hr_utility.set_location('l_bal_flag : '|| l_bal_flag,20);
4766: -------------Bug 8872583
4767: l_amt:=ben_distribute_rates.period_to_annual
4768: (p_amount => l_amt
4769: ,p_enrt_rt_id => l_enrt_rt_id--------Bug 7196470
4770: ,p_acty_ref_perd_cd => p_acty_ref_perd
4771: ,p_business_group_id => p_business_group_id
4783: l_amt := round(l_amt,4);
4784: --
4785: else
4786: --
4787: l_amt:=ben_distribute_rates.period_to_annual
4788: (p_amount => l_amt
4789: ,p_acty_ref_perd_cd => p_acty_ref_perd
4790: ,p_business_group_id => p_business_group_id
4791: ,p_effective_date => l_rt_strt_dt
4831: l_prnt_ann_rt = 'Y' then
4832: l_annual_target := true;
4833: end if;
4834: --
4835: l_per_pay_amt:=ben_distribute_rates.annual_to_period
4836: (p_amount =>l_amt
4837: ,p_acty_ref_perd_cd =>l_perd_cd
4838: ,p_business_group_id =>p_business_group_id
4839: ,p_effective_date =>l_rt_strt_dt
4897: if l_get_abr_info.entr_ann_val_flag='Y' or
4898: l_mlt_cd = 'SAREC' or
4899: l_prnt_ann_rt = 'Y' then
4900: --
4901: l_pay_periods:=ben_distribute_rates.get_periods_between(
4902: p_acty_ref_perd_cd =>l_perd_cd --'PP'
4903: ,p_start_date =>l_range_start
4904: ,p_end_date =>l_last_pp_end_dt
4905: ,p_payroll_id =>l_payroll_id
4911: );
4912:
4913: else
4914: --
4915: l_pay_periods:=ben_distribute_rates.get_periods_between(
4916: p_acty_ref_perd_cd =>l_perd_cd --'PP'
4917: ,p_start_date =>l_range_start
4918: ,p_end_date =>l_last_pp_end_dt
4919: ,p_payroll_id =>l_payroll_id
4952: --
4953: -- First get the real number of periods left.
4954: --
4955: if nvl(l_lf_evt_ocrd_dt,p_effective_date) < l_last_pp_end_dt then
4956: l_real_num_periods:=ben_distribute_rates.get_periods_between
4957: (p_acty_ref_perd_cd =>l_perd_cd --PP'
4958: ,p_start_date => l_rt_strt_dt --p_effective_date
4959: ,p_end_date => l_last_pp_end_dt
4960: ,p_payroll_id => l_payroll_id
4961: ,p_business_group_id => p_business_group_id
4962: ,p_element_type_id => l_element_type_id
4963: ,p_effective_date => nvl(l_lf_evt_ocrd_dt,p_effective_date));
4964: else
4965: l_real_num_periods:=ben_distribute_rates.get_periods_between
4966: (p_acty_ref_perd_cd =>l_perd_cd --PP'
4967: ,p_start_date => nvl(l_lf_evt_ocrd_dt,p_effective_date)
4968: ,p_payroll_id => l_payroll_id
4969: ,p_business_group_id => p_business_group_id
9634: hr_utility.set_location('range start= '|| l_range_start,10);
9635: hr_utility.set_location('range end = '|| l_last_pp_end_dt,10);
9636: hr_utility.set_location('p_amt='||p_amt,100);
9637: end if;
9638: l_amt:=ben_distribute_rates.period_to_annual(
9639: p_amount =>p_amt
9640: ,p_acty_ref_perd_cd =>p_acty_ref_perd
9641: ,p_business_group_id =>p_business_group_id
9642: ,p_effective_date =>p_effective_date
9661: --
9662: if l_ele_entry_val_cd = 'EPP' then
9663: l_perd_cd := 'EPP';
9664: end if;
9665: l_per_pay_amt:=ben_distribute_rates.annual_to_period(
9666: p_amount =>l_amt
9667: ,p_acty_ref_perd_cd =>l_perd_cd --'PP' -- per pay period
9668: ,p_business_group_id =>p_business_group_id
9669: ,p_effective_date =>p_effective_date