DBA Data[Home] [Help]

APPS.PER_VIEWS_PKG dependencies on PER_ALL_ASSIGNMENTS_F

Line 488: from PER_ALL_ASSIGNMENTS_F

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

Line 494: from PER_ALL_ASSIGNMENTS_F

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