[Home] [Help]
317: -- Bug 2943335 - commented code below to reference element entries table for data
318: --
319: /* cursor c_soc_ben(c_payroll_id number,c_date_earned date) is select calculation_option
320: ,nvl(reduced_tax_credit,0)
321: ,nvl(reduced_standard_cutoff,0)
322: ,nvl(benefit_amount,0)
323: from pay_ie_social_benefits_f psb,
324: per_time_periods ptp
325: where psb.absence_start_date between ptp.start_date and ptp.end_date
449: /*Social Benefits stuff*/
450: /* open c_soc_ben(l_payroll_id,l_date_earned);
451: fetch c_soc_ben into l_soc_ben_rec.calculation_option
452: ,l_soc_ben_rec.reduced_tax_credit
453: ,l_soc_ben_rec.reduced_standard_cutoff
454: ,l_soc_ben_rec.benefit_amount;
455: if c_soc_ben%found then
456:
457: -- getting calculated values according to the period
455: if c_soc_ben%found then
456:
457: -- getting calculated values according to the period
458: l_cal_reduced_tax_credit := get_calculated_period_values(l_period_type,l_period_ind,l_soc_ben_rec.reduced_tax_credit);
459: l_cal_reduced_cut_off:= get_calculated_period_values(l_period_type,l_period_ind,l_soc_ben_rec.reduced_standard_cutoff);
460:
461: if l_soc_ben_rec.calculation_option = 'IE_OPTION1' then
462: --
463: p_benefit_amount:=l_soc_ben_rec.benefit_amount;
797: CLOSE get_pay_frequency_csr;
798: --
799: IF p_tax_basis='IE_EMERGENCY' THEN
800: IF get_pay_frequency_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year') THEN
801: OPEN get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF');
802: FETCH get_global_val INTO v_monthly_std_rate_cut_off;
803: CLOSE get_global_val;
804: ELSE
805: v_monthly_std_rate_cut_off:= NULL;
929: IF get_pay_frequency_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year') THEN
930: v_weekly_std_rate_cut_off:= NULL;
931: --
932: ELSE
933: OPEN get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF');
934: FETCH get_global_val INTO v_weekly_std_rate_cut_off;
935: CLOSE get_global_val;
936: --
937: END IF;
1197: hr_utility.set_location('l_new_flag =1',856);
1198: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1199: fetch get_global_val into l_monthly_tax_credit;
1200: close get_global_val;
1201: open get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF',l_effective_date);
1202: fetch get_global_val into l_monthly_std_rate_cut_off;
1203: close get_global_val;
1204: /* For monthly payroll, weekly values must be null */
1205: l_weekly_tax_credit :=NULL;
1208: hr_utility.set_location('l_new_flag =0',857);
1209: open get_global_val('IE_WEEKLY_TAX_CREDIT',l_effective_date);
1210: fetch get_global_val into l_weekly_tax_credit;
1211: close get_global_val;
1212: open get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF',l_effective_date);
1213: fetch get_global_val into l_weekly_std_rate_cut_off;
1214: close get_global_val;
1215: /* For weekly payroll, monthly values must be null */
1216: l_monthly_tax_credit :=NULL;