APPS.PER_VACANCIES_PKG dependencies on PER_REQUISITIONS

Line 325: FROM PER_REQUISITIONS PR

321: P_vac_date_from DATE) IS
322:
323: CURSOR c_check_in_req_dates IS
324: SELECT 1
325: FROM PER_REQUISITIONS PR
326: WHERE PR.REQUISITION_ID = P_requisition_id
327: AND PR.business_group_id + 0 = P_Business_group_id
328: AND P_vac_date_from < PR.DATE_FROM;
329:

Line 360: FROM PER_REQUISITIONS PR

356: P_vac_date_to DATE) IS
357:
358: CURSOR c_in_req_dt IS
359: SELECT 1
360: FROM PER_REQUISITIONS PR
361: WHERE PR.REQUISITION_ID = P_requisition_id
362: AND PR.business_group_id + 0 = P_Business_group_id
363: AND NVL(P_vac_date_to,to_date('31-12-4712','DD-MM-YYYY')) > PR.DATE_TO;
364: