DBA Data[Home] [Help]

APPS.PQP_LOG_ALIEN_DATA_CHANGES dependencies on PER_ASSIGNMENTS_F

Line 205: FROM per_assignments_f

201: WHERE session_id = userenv('sessionid');
202: --
203: CURSOR c_assign IS
204: SELECT assignment_id
205: FROM per_assignments_f
206: WHERE person_id = p_person_id
207: --AND effective_end_date >= NVL(l_session_date, sysdate);
208: AND NVL(l_session_date, sysdate) BETWEEN
209: effective_start_date AND effective_end_date;