APPS.PER_EVENTS_PKG dependencies on HR_ORGANIZATION_UNITS

Line 33: FROM hr_organization_units H

29: effective_Start_date and effective_end_Date;
30:
31: CURSOR CH2 IS
32: SELECT 1
33: FROM hr_organization_units H
34: WHERE H.business_group_id + 0 = X_BUSINESS_GROUP_ID
35: AND X_DATE_START BETWEEN H.date_from
36: and NVL(H.date_to , X_CTL_GLOBALS_END_OF_TIME)
37: AND H.ORGANIZATION_ID = X_ORGANIZATION_RUN_BY_ID;