DBA Data[Home] [Help]

APPS.PER_VACANCIES_PKG dependencies on PER_REQUISITIONS

Line 317: FROM PER_REQUISITIONS PR

313: P_vac_date_from DATE) IS
314:
315: CURSOR c_check_in_req_dates IS
316: SELECT 1
317: FROM PER_REQUISITIONS PR
318: WHERE PR.REQUISITION_ID = P_requisition_id
319: AND PR.business_group_id + 0 = P_Business_group_id
320: AND P_vac_date_from < PR.DATE_FROM;
321:

Line 352: FROM PER_REQUISITIONS PR

348: P_vac_date_to DATE) IS
349:
350: CURSOR c_in_req_dt IS
351: SELECT 1
352: FROM PER_REQUISITIONS PR
353: WHERE PR.REQUISITION_ID = P_requisition_id
354: AND PR.business_group_id + 0 = P_Business_group_id
355: AND P_vac_date_to > PR.DATE_TO;
356: