[Home] [Help]
31: ** 09-DEC-2002 smrobins N/A Added function get_pps_number.
32: ** 16-MAY-2003 nsugavan 2943335 Added function Valid_Work_incidents and made
33: ** changes to existing social benefits cursor
34: ** to use element entry values instead of data
35: ** from table, pay_ie_social_benefits_f
36: ** 04-jul-2003 asengar 3030621 Added two procedures insert_element_entry
37: ** and update_element_entry.
38: ** 30-JUL-2003 asengar 3030616 Added four functions get_weekly_tax_credit
39: ** get_weekly_std_rate_cut_off,get_monthly_tax_credit
276: l_proc varchar2(72) := g_package||'get_paye_details';
277: l_payroll_id number;
278: l_date_earned date;
279: l_period_type varchar2(20);
280: l_soc_ben_rec pay_ie_social_benefits_f%rowtype;
281:
282: -- added for getting calculated values as per period type
283: l_period_ind varchar2(3);
284: l_cal_reduced_tax_credit number;
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
326: and ptp.payroll_id = c_payroll_id
327: and psb.assignment_id = p_assignment_id