[Home] [Help]
327: -- Bug 2943335 - commented code below to reference element entries table for data
328: --
329: /* cursor c_soc_ben(c_payroll_id number,c_date_earned date) is select calculation_option
330: ,nvl(reduced_tax_credit,0)
331: ,nvl(reduced_standard_cutoff,0)
332: ,nvl(benefit_amount,0)
333: from pay_ie_social_benefits_f psb,
334: per_time_periods ptp
335: where psb.absence_start_date between ptp.start_date and ptp.end_date
459: /*Social Benefits stuff*/
460: /* open c_soc_ben(l_payroll_id,l_date_earned);
461: fetch c_soc_ben into l_soc_ben_rec.calculation_option
462: ,l_soc_ben_rec.reduced_tax_credit
463: ,l_soc_ben_rec.reduced_standard_cutoff
464: ,l_soc_ben_rec.benefit_amount;
465: if c_soc_ben%found then
466:
467: -- getting calculated values according to the period
465: if c_soc_ben%found then
466:
467: -- getting calculated values according to the period
468: l_cal_reduced_tax_credit := get_calculated_period_values(l_period_type,l_period_ind,l_soc_ben_rec.reduced_tax_credit);
469: l_cal_reduced_cut_off:= get_calculated_period_values(l_period_type,l_period_ind,l_soc_ben_rec.reduced_standard_cutoff);
470:
471: if l_soc_ben_rec.calculation_option = 'IE_OPTION1' then
472: --
473: p_benefit_amount:=l_soc_ben_rec.benefit_amount;
929: CLOSE get_pay_frequency_csr;
930: --
931: IF p_tax_basis='IE_EMERGENCY' THEN
932: IF get_pay_frequency_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year') THEN
933: OPEN get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF');
934: FETCH get_global_val INTO v_monthly_std_rate_cut_off;
935: CLOSE get_global_val;
936: ELSE
937: v_monthly_std_rate_cut_off:= NULL;
1061: IF get_pay_frequency_rec.period_type IN ('Calendar Month', 'Quarter', 'Bi-Month', 'Semi-Month', 'Semi-Year', 'Year') THEN
1062: v_weekly_std_rate_cut_off:= NULL;
1063: --
1064: ELSE
1065: OPEN get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF');
1066: FETCH get_global_val INTO v_weekly_std_rate_cut_off;
1067: CLOSE get_global_val;
1068: --
1069: END IF;
1408: hr_utility.set_location('l_new_flag =1',856);
1409: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1410: fetch get_global_val into l_monthly_tax_credit;
1411: close get_global_val;
1412: open get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF',l_effective_date);
1413: fetch get_global_val into l_monthly_std_rate_cut_off;
1414: close get_global_val;
1415: /* For monthly payroll, weekly values must be null */
1416: l_weekly_tax_credit :=NULL;
1419: hr_utility.set_location('l_new_flag =0',857);
1420: open get_global_val('IE_WEEKLY_TAX_CREDIT',l_effective_date);
1421: fetch get_global_val into l_weekly_tax_credit;
1422: close get_global_val;
1423: open get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF',l_effective_date);
1424: fetch get_global_val into l_weekly_std_rate_cut_off;
1425: close get_global_val;
1426: /* For weekly payroll, monthly values must be null */
1427: l_monthly_tax_credit :=NULL;