DBA Data[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;