[Home] [Help]
2149:
2150: -- System-created stoppages for the PIW which have not been overridden
2151: cursor csr_old_stoppages is
2152: select stp.*
2153: from ssp_stoppages STP
2154: where stp.absence_attendance_id = g_PIW_id
2155: and ((stp.override_stoppage <> 'Y' and stp.user_entered <> 'Y')
2156: or
2157: (stp.withhold_from > PIW_end_date));
2303: -- effective because that is the last day of payment.
2304: --
2305: cursor csr_last_entitled_day is
2306: select nvl (min (withhold_from),hr_general.end_of_time) -1
2307: from ssp_stoppages
2308: where absence_attendance_id = g_PIW_id
2309: and override_stoppage <> 'Y'
2310: and withhold_to is null;
2311: --
2394: -- Return rows if the period in question is covered by stoppages
2395: cursor csr_stoppages(p_effective_start_date in date,
2396: p_effective_end_date in date) is
2397: select withhold_from, withhold_to
2398: from ssp_stoppages
2399: where absence_attendance_id = g_PIW_id
2400: and override_stoppage = 'N'
2401: and withhold_to is not null
2402: and ((p_effective_start_date <= withhold_from and
2407: p_effective_start_date <= nvl(withhold_to,hr_general.end_of_time)
2408: ))
2409: union all
2410: select withhold_from, withhold_to
2411: from ssp_stoppages ss,
2412: per_absence_attendances paa
2413: where paa.linked_absence_id = g_PIW_id
2414: and paa.absence_attendance_id = ss.absence_attendance_id
2415: and override_stoppage = 'N'
2843: l_found boolean;
2844:
2845: cursor csr_old_stp is
2846: select 1
2847: from ssp_stoppages stp,
2848: ssp_withholding_reasons rea
2849: where stp.absence_attendance_id = g_PIW_id
2850: and stp.withhold_from <= p_start
2851: and stp.withhold_to >= p_end
4355: --
4356: cursor csr_previous_reason is
4357: select count(*)
4358: from ssp_withholding_reasons swr,
4359: ssp_stoppages stp
4360: where stp.absence_attendance_id = p_absence_attendance_id
4361: and stp.reason_id = swr.reason_id
4362: and upper(swr.reason) = 'RE-HIRED EMPLOYEE,PLEASE CHECK';
4363: --