DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PERFORMANCE_REVIEWS

Line 6734: FROM per_performance_reviews ppr, per_events pev

6730: p_lf_evt_ocrd_dt DATE
6731: )
6732: IS
6733: SELECT ppr.performance_rating
6734: FROM per_performance_reviews ppr, per_events pev
6735: WHERE pev.assignment_id = p_assignment_id
6736: AND pev.TYPE = p_event_type
6737: AND pev.business_group_id = p_business_group_id
6738: AND p_lf_evt_ocrd_dt BETWEEN NVL (date_start, p_lf_evt_ocrd_dt)

Line 6756: FROM per_performance_reviews ppr

6752: p_effective_date DATE
6753: )
6754: IS
6755: SELECT ppr.performance_rating
6756: FROM per_performance_reviews ppr
6757: WHERE ppr.person_id = p_person_id
6758: -- AND ppr.performance_rating = p_performance_rating
6759: AND ppr.review_date <= p_effective_date
6760: AND ppr.event_id IS NULL