[Home] [Help]
APPS.HRI_OPL_REC_CAND_PIPLN dependencies on HRI_MB_ASGN_EVENTS_CT
Line 2249: FROM hri_mb_asgn_events_ct evt
2245: SELECT
2246: effective_change_date
2247: ,perf_nrmlsd_rating
2248: ,perf_band
2249: FROM hri_mb_asgn_events_ct evt
2250: WHERE assignment_id = v_asg_id
2251: AND effective_change_date BETWEEN v_hire_date
2252: AND add_months(v_hire_date, 24)
2253: AND perf_rating_change_ind = 1;