484: return date
485: IS
486: CURSOR E_DATE1 is
487: select min(EFFECTIVE_START_DATE) - 1
488: from PER_ALL_ASSIGNMENTS_F
489: where ASSIGNMENT_ID = p_assignment_id
490: and EFFECTIVE_START_DATE > p_effective_start_date ;
491:
492: CURSOR E_DATE2 is
490: and EFFECTIVE_START_DATE > p_effective_start_date ;
491:
492: CURSOR E_DATE2 is
493: select max(EFFECTIVE_END_DATE)
494: from PER_ALL_ASSIGNMENTS_F
495: where ASSIGNMENT_ID = p_assignment_id ;
496:
497: d_date date ;
498: BEGIN