DBA Data[Home] [Help]

APPS.BEN_EVALUATE_RATE_PROFILES dependencies on PER_EVENTS

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)