APPS.OTA_EVT_BUS dependencies on HR_LOCATIONS_ALL

Line 3471: From HR_LOCATIONS_ALL loc

3467: l_exists varchar2(1);
3468: Cursor c_location
3469: IS
3470: Select null
3471: From HR_LOCATIONS_ALL loc
3472: Where loc.location_id = p_location_id
3473: and nvl(loc.inactive_date,to_date('31-12-4712','DD-MM-YYYY')) >= nvl(p_course_end_date,sysdate);
3474:
3475: Begin