APPS.PER_RECRUITMENT_ACTIVITIES_PKG dependencies on HR_ORGANIZATION_UNITS
Line 165: FROM hr_organization_units
161: P_Business_Group_id NUMBER) IS
162: --
163: CURSOR csr_org_dates IS
164: SELECT organization_id 165: FROM hr_organization_units 166: WHERE organization_id = P_org_run_by_Id
167: AND business_group_id + 0 = P_Business_Group_id
168: AND date_from <= P_date_start
169: AND ((date_to is null) or