APPS.OTA_EVT_BUS dependencies on HR_LOCATIONS_ALL

Line 3451: From HR_LOCATIONS_ALL loc

3447: l_exists varchar2(1);
3448: Cursor c_location
3449: IS
3450: Select null
3451: From HR_LOCATIONS_ALL loc
3452: Where loc.location_id = p_location_id
3453: and nvl(loc.inactive_date,to_date('31-12-4712','DD-MM-YYYY')) >= nvl(p_course_end_date,sysdate);
3454:
3455: Begin