DBA Data[Home] [Help]

APPS.BEN_EVALUATE_ELIG_PROFILES dependencies on PER_PERFORMANCE_REVIEWS

Line 8334: FROM per_performance_reviews ppr,

8330: p_effective_date DATE
8331: )
8332: IS
8333: SELECT ppr.performance_rating
8334: FROM per_performance_reviews ppr,
8335: per_events pev,
8336: per_all_assignments_f asg
8337: WHERE pev.assignment_id = asg.assignment_id
8338: AND pev.TYPE = p_event_type

Line 8368: FROM per_performance_reviews ppr

8364: p_effective_date DATE
8365: )
8366: IS
8367: SELECT ppr.performance_rating
8368: FROM per_performance_reviews ppr
8369: WHERE ppr.person_id = p_person_id
8370: AND ppr.review_date <= p_effective_date
8371: AND ppr.event_id IS NULL
8372: ORDER BY ppr.review_date desc;