APPS.PER_MX_GEN_HIER_VALID dependencies on HR_ORGANIZATION_UNITS

Line 233: from hr_organization_units

229:
230: CURSOR c_get_loc_id( cp_bus_grp_id number
231: ,cp_org_id number) IS
232: select location_id
233: from hr_organization_units
234: where business_group_id = cp_bus_grp_id
235: and organization_id = cp_org_id;
236:
237: ln_location_id number;