DBA Data[Home] [Help]

APPS.SSP_SSP_PKG dependencies on SSP_WITHHOLDING_REASONS

Line 2962: ssp_withholding_reasons rea

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

Line 4490: from ssp_withholding_reasons swr,

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