DBA Data[Home] [Help]

APPS.BEN_EXT_THREAD dependencies on HR_ALL_ORGANIZATION_UNITS_VL

Line 4919: from hr_all_organization_units_vl org

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