APPS.HRI_EDW_FCT_WRK_ACTVTY dependencies on PER_PERIODS_OF_SERVICE

Line 54: FROM per_periods_of_service

50:
51: /* Selects the start date for the effective period of service */
52: CURSOR hire_cur IS
53: SELECT MAX(date_start)
54: FROM per_periods_of_service
55: WHERE person_id = p_person_id
56: AND date_start <= p_effective_date;
57:
58: BEGIN