APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on HR_ORGANIZATION_INFORMATION
Line 2317: hr_organization_information hoi
2313: --
2314: cursor c_get_mapping_name4(p_id in number,p_date in date) is
2315: select hou.name dsp_name
2316: from hr_organization_units_v hou , 2317: hr_organization_information hoi 2318: where business_group_id = p_business_group_id
2319: and hou.organization_id = p_id
2320: and p_date between date_from and nvl(date_to, p_date)
2321: and hou.organization_id = hoi.organization_id