DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 4921: from hr_all_organization_units_vl org

4917:
4918: cursor c_org (p_bg_id number ) is
4919: select org.organization_id
4920: ,org.name
4921: from hr_all_organization_units_vl org
4922: where org.business_group_id = p_bg_id
4923: and p_effective_date between org.date_from and nvl(org.date_to,p_effective_date) ;
4924:
4925: