DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PERFORMANCE_REVIEWS

Line 8352: FROM per_performance_reviews ppr,

8348: p_effective_date DATE
8349: )
8350: IS
8351: SELECT ppr.performance_rating
8352: FROM per_performance_reviews ppr,
8353: per_events pev,
8354: per_all_assignments_f asg
8355: WHERE pev.assignment_id = asg.assignment_id
8356: AND pev.TYPE = p_event_type

Line 8386: FROM per_performance_reviews ppr

8382: p_effective_date DATE
8383: )
8384: IS
8385: SELECT ppr.performance_rating
8386: FROM per_performance_reviews ppr
8387: WHERE ppr.person_id = p_person_id
8388: AND ppr.review_date <= p_effective_date
8389: AND ppr.event_id IS NULL
8390: ORDER BY ppr.review_date desc;