DBA Data[Home] [Help]

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