APPS.HR_PERSON_RECORD dependencies on HR_ORGANIZATION_UNITS

Line 1564: from hr_organization_units org

1560:
1561: if p_srch_criteria(i).p_bgrp_name is not null
1562: then
1563: select business_group_id into p_bus_group_id
1564: from hr_organization_units org
1565: where upper(name) = upper(p_srch_criteria(i).p_bgrp_name)
1566: and org.organization_id = org.business_group_id
1567: and p_srch_criteria(i).p_effective_date between date_from and
1568: nvl (date_to, to_date('31-12-4712', 'DD-MM-YYYY'));