eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_PERFORMANCE_REVIEWS

Line 6791: FROM per_performance_reviews ppr, per_events pev

6787: p_lf_evt_ocrd_dt DATE
6788: )
6789: IS
6790: SELECT ppr.performance_rating
6791: FROM per_performance_reviews ppr, per_events pev
6792: WHERE NVL(pev.assignment_id,p_assignment_id) = p_assignment_id /* Bug 9679606: added nvl condition */
6793: AND pev.TYPE = p_event_type
6794: AND NVL(pev.business_group_id,p_business_group_id) = p_business_group_id /* Bug 9679606: added nvl condition */
6795: AND p_lf_evt_ocrd_dt BETWEEN NVL (date_start, p_lf_evt_ocrd_dt)

Line 6813: FROM per_performance_reviews ppr

6809: p_effective_date DATE
6810: )
6811: IS
6812: SELECT ppr.performance_rating
6813: FROM per_performance_reviews ppr
6814: WHERE ppr.person_id = p_person_id
6815: -- AND ppr.performance_rating = p_performance_rating
6816: AND ppr.review_date <= p_effective_date
6817: AND ppr.event_id IS NULL