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: