APPS.AMS_APPROVAL_DETAILS_PVT dependencies on HR_ORGANIZATION_UNITS

Line 1716: FROM hr_organization_units hou

1712: CURSOR c_get_org(cur_organization_id number,
1713: cur_business_group_id number,
1714: cur_org_type varchar2) is
1715: SELECT count(1)
1716: FROM hr_organization_units hou
1717: WHERE hou.organization_id = cur_organization_id
1718: --AND hou.business_group_id = cur_business_group_id
1719: AND hou.type = nvl(cur_org_type,hou.type)
1720: AND sysdate between hou.date_from and nvl(hou.date_to,sysdate +1 );