[Home] [Help]
2260:
2261: -- System-created stoppages for the PIW which have not been overridden
2262: cursor csr_old_stoppages is
2263: select stp.*
2264: from ssp_stoppages STP
2265: where stp.absence_attendance_id = g_PIW_id
2266: and ((stp.override_stoppage <> 'Y' and stp.user_entered <> 'Y')
2267: or
2268: (stp.withhold_from > PIW_end_date));
2417: -- effective because that is the last day of payment.
2418: --
2419: cursor csr_last_entitled_day is
2420: select nvl (min (withhold_from),hr_general.end_of_time) -1
2421: from ssp_stoppages
2422: where absence_attendance_id = g_PIW_id
2423: and override_stoppage <> 'Y'
2424: and withhold_to is null;
2425: --
2508: -- Return rows if the period in question is covered by stoppages
2509: cursor csr_stoppages(p_effective_start_date in date,
2510: p_effective_end_date in date) is
2511: select withhold_from, withhold_to
2512: from ssp_stoppages
2513: where absence_attendance_id = g_PIW_id
2514: and override_stoppage = 'N'
2515: and withhold_to is not null
2516: and ((p_effective_start_date <= withhold_from and
2521: p_effective_start_date <= nvl(withhold_to,hr_general.end_of_time)
2522: ))
2523: union all
2524: select withhold_from, withhold_to
2525: from ssp_stoppages ss,
2526: per_absence_attendances paa
2527: where paa.linked_absence_id = g_PIW_id
2528: and paa.absence_attendance_id = ss.absence_attendance_id
2529: and override_stoppage = 'N'
2957: l_found boolean;
2958:
2959: cursor csr_old_stp is
2960: select 1
2961: from ssp_stoppages stp,
2962: ssp_withholding_reasons rea
2963: where stp.absence_attendance_id = g_PIW_id
2964: and stp.withhold_from <= p_start
2965: and stp.withhold_to >= p_end
4487: --
4488: cursor csr_previous_reason is
4489: select count(*)
4490: from ssp_withholding_reasons swr,
4491: ssp_stoppages stp
4492: where stp.absence_attendance_id = p_absence_attendance_id
4493: and stp.reason_id = swr.reason_id
4494: and upper(swr.reason) = 'RE-HIRED EMPLOYEE,PLEASE CHECK';
4495: --