[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
286: l_proc varchar2(72) := g_package||'get_paye_details';
287: l_payroll_id number;
288: l_date_earned date;
289: l_period_type varchar2(20);
290: l_soc_ben_rec pay_ie_social_benefits_f%rowtype;
291:
292: -- added for getting calculated values as per period type
293: l_period_ind varchar2(3);
294: l_cal_reduced_tax_credit number;
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
336: and ptp.payroll_id = c_payroll_id
337: and psb.assignment_id = p_assignment_id