APPS.HR_ORD_BUS dependencies on HR_ORGANIZATION_UNITS

Line 25: from hr_organization_units org

21: (p_effective_date in date
22: ,p_business_group_id in number
23: ,p_organization_id in number) is
24: select org.organization_id
25: from hr_organization_units org
26: where org.organization_id = p_organization_id
27: and org.business_group_id = p_business_group_id
28: and p_effective_date between org.date_from and nvl(org.date_to, to_date('31/12/4712', 'DD/MM/YYYY'));
29: --