DBA Data[Home] [Help]

APPS.HR_SECURITY dependencies on HR_ORGANIZATION_INFORMATION

Line 1840: FROM hr_organization_information oi

1836: -- Gets all inventory orgs belonging to a particular operating unit.
1837: --
1838: CURSOR c_get_inventory_org (org_id IN NUMBER) IS
1839: SELECT null
1840: FROM hr_organization_information oi
1841: WHERE oi.organization_id = p_org_id
1842: AND oi.org_information_context = 'Accounting Information'
1843: AND to_number(oi.org_information3) = org_id;
1844: