APPS.HR_PERSON_RECORD dependencies on HR_ORGANIZATION_UNITS

Line 2405: from hr_organization_units org

2401:
2402: if p_srch_criteria(i).p_bgrp_name is not null
2403: then
2404: select business_group_id into p_bus_group_id
2405: from hr_organization_units org
2406: where upper(name) = upper(p_srch_criteria(i).p_bgrp_name)
2407: and org.organization_id = org.business_group_id
2408: and p_srch_criteria(i).p_effective_date between date_from and
2409: nvl (date_to, to_date('31-12-4712', 'DD-MM-YYYY'));