[Home] [Help]
62: pay_element_entry_values_f.input_value_id
63: Also included new Change List Header.
64:
65: 70.39 07-AUG-1997 Mbocutt Change hardcoded date usage to use
66: 110.1 hr_general.end_of_time
67: 70.40 23-OCT-1997 565478 ASAHAY modified cursor in b_check_auth_de
68: 110.1 and b_check_rep_de to check for
69: correct start date and end date
70: 70.42 05-MAY-1998 563202 AParkes Performance fix for SSP; Altered
263: c2_rec c2%ROWTYPE;
264: --
265: begin
266: p_nos_absences := 0;
267: p_earliest_abs_start_date := hr_general.end_of_time;
268: --
269: for c2_rec in c2 LOOP
270: p_nos_absences := p_nos_absences + 1;
271: --
394: 'AA',ssp_apad_pkg.earliest_ASPPP_start_date(placement_date),
395: ssp_smp_pkg.earliest_MPP_start_date (due_date))
396: earliest_MPP_start_date,
397: ssp_smp_pkg.qualifying_week (due_date) QW,
398: nvl(mpp_start_date,hr_general.end_of_time) MPP,
399: person_id,
400: leave_type,
401: placement_date,
402: due_date,
408: where maternity_id = p_maternity_id;
409: --
410: l_maternity csr_MPP%rowtype;
411: l_default_MPP_start_date date := null;
412: l_end_date date := nvl (p_end_date, hr_general.end_of_time);
413: l_current_mpp_start_date date := hr_general.end_of_time;
414: l_earliest_abs_start_date date;
415: l_ewc date;
416: l_earliest_mpp_start date;
409: --
410: l_maternity csr_MPP%rowtype;
411: l_default_MPP_start_date date := null;
412: l_end_date date := nvl (p_end_date, hr_general.end_of_time);
413: l_current_mpp_start_date date := hr_general.end_of_time;
414: l_earliest_abs_start_date date;
415: l_ewc date;
416: l_earliest_mpp_start date;
417: l_qw date;
1769: --
1770: if X_sickness_start_date is not null
1771: and (l_absence.sickness_start_date <> X_sickness_start_date
1772: or nvl (l_absence.sickness_end_date,
1773: hr_general.end_of_time) <> nvl (X_sickness_end_date,
1774: hr_general.end_of_time) )
1775: then
1776: --
1777: -- The sickness dates are being updated. Make sure that the PIW series is
1770: if X_sickness_start_date is not null
1771: and (l_absence.sickness_start_date <> X_sickness_start_date
1772: or nvl (l_absence.sickness_end_date,
1773: hr_general.end_of_time) <> nvl (X_sickness_end_date,
1774: hr_general.end_of_time) )
1775: then
1776: --
1777: -- The sickness dates are being updated. Make sure that the PIW series is
1778: -- not affected as a result of the update.
2802: from per_periods_of_service pos
2803: where pos.person_id = p_per_id
2804: and pos.date_start > p_curr_date_end
2805: and p_proj_start between
2806: pos.date_start AND nvl(pos.actual_termination_date,hr_general.end_of_time);
2807: --
2808: begin
2809: --
2810: hr_utility.set_location('per_absence_attendances_pkg.chk_serv_period',1);
2937: Procedure check_val_abs_start (p_date_start in date,
2938: p_maternity_id in number) is
2939: Cursor csr_maternity is
2940: select ssp_smp_pkg.qualifying_week (mat.due_date) QW,
2941: nvl(mat.mpp_start_date,hr_general.end_of_time) MPP,
2942: nvl(mat.leave_type,'MA') leave_type
2943: from ssp_maternities MAT
2944: where mat.maternity_id = p_maternity_id;
2945: --
2997: /* Bug Fix 13486124, included Adjusted service date in the check
2998: and date_start <= continous_emp_date
2999: */
3000: and least(nvl(adjusted_svc_date,date_start),date_start) <= continous_emp_date
3001: and nvl (actual_termination_date, hr_general.end_of_time)
3002: > p_date_start;
3003:
3004: maternity csr_maternity%ROWTYPE;
3005: l_dummy period_of_service%ROWTYPE;