APPS.DT_CHECKINT dependencies on HR_GENERAL

Line 410: if ( ( p_last_row.effective_end_date = hr_general.end_of_time )

406: begin
407:
408: if ( p_current_row.id_value = p_last_row.id_value ) then
409:
410: if ( ( p_last_row.effective_end_date = hr_general.end_of_time )
411: OR ( p_current_row.effective_start_date < p_last_row.effective_end_date + 1 ) )
412: then
413:
414: return( 'OVERLAPS PREVIOUS ROW' ) ;

Line 416: elsif ( ( p_last_row.effective_end_date <> hr_general.end_of_time )

412: then
413:
414: return( 'OVERLAPS PREVIOUS ROW' ) ;
415:
416: elsif ( ( p_last_row.effective_end_date <> hr_general.end_of_time )
417: AND ( p_current_row.effective_start_date > p_last_row.effective_end_date + 1 ) ) then
418:
419: return('GAP WITH PREVIOUS ROW') ;
420: