DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on SSP_WITHHOLDING_REASONS

Line 2848: ssp_withholding_reasons rea

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
2852: and stp.reason_id = rea.reason_id

Line 4358: from ssp_withholding_reasons swr,

4354: l_rows_reason number:=0;
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';